Hello! I’m working on an automation to send an email under certain conditions.
I have two tables: Courses and Students, and the automation triggers when I make a given change to an entry in Students. It then should find the Course with the given course code from the Students entry, and send an email to the Student with some looked-up info from the Course.
One example of something I want to embed is the Course’s schedule, which is a formula, returning text, in the Course table.
I can successfully find the record from Courses, but the problem is that, when I hit “+” and drill through:
Records (from Step 4: Find records)
→ Records
→ Field values
→ Schedule, hit “continue”
the only thing available to embed is “length”, not the actual field value. Some other fields I can successfully embed, including fields that are Linked to Another Table.
Maybe this has to do with the results of the Find being a list, but I’m guaranteed only to ever get one result (as the course codes are unique).
Anyway, how can I include the results of these formulae in my email?