Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 07, 2021 09:53 AM
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?
Jan 15, 2021 01:11 AM
Hi @Brite_Admin
Not sure if this is possible in Airtable. Did you have look at the Zapier possibilities (eg with “find record” step)?