I have two tables. The NAMES table has Names & Addresses
The MESSAGES Table has a DATE field with every day for this year, and a Message fField with a different message for each day.
My use case is automating a way to send a text message to every name in the Names table.
I tried creating a Formula field for now() in theNAMES table so each record has today’s date. I was thinking I could then use a lookup to bring in the appropriate messag (Today’s Message) into the Names Table but evidently, I can’t use a formula field as the basis if a lookup.
Can someone suggest how I can accomplish this?