Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Hi! I would greatly appreciate any help. I am trying to build an automation where I send an email to myself when a client’s contract is about to end. I want to include information like what the client previously paid for and how long their previous contract is in the email. This information is in a table where each record is a separate client and the length of previous contract & program type are both columns of single select fields. For some reason, when I try to add the value in the field to my automation it shows up as blank, but when I change the field type to “multiple select” I am able to select the data in the field. Why is this happening? Image below, where you can see for some fields data is populated, but for others there is no data even though the field is filled in on the table.
Hi Roshini, if you’ve tried refreshing the data your setup automation is using and you’re still facing this issue you might want to open a support ticket about it
