1

New here. I'll be as brief as I can. I'm trying to trigger a mail before a subscription expiry date.

I have two tables: A 'Contact' Table and an 'Account' Table.

How can I add an 'Account Expiry' Date field from the Account table as an option in this drop down? Or indeed any other new field I create in the Contact table.

Any help appreciated!

workflow time trigger edit

1
  • Can you please share your work flow rule-criteria as well?
    – Mahmood
    Nov 27, 2014 at 13:04

1 Answer 1

2

Easiest way would be to create a new formula field on Contact, with type Date, referring the Date field on Account.

The formula would be:

Account.Account__Expiry__c

The new formula field will then appear in the dropdown.

1
  • Thanks Guy - thought it might be something like that. Help appreciated.
    – MikeAdmin
    Nov 27, 2014 at 14:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .