Skip to main content ↑ ↓
Topic: [ADD RECORD PAGE] how to reference field from joined table on email (Read 1190 times) previous topic - next topic

[ADD RECORD PAGE] how to reference field from joined table on email

Hello all,
I need to send an emal after the user add a record to the application.
Actually I use the "Mail Actions Settings" to send the email.
I know how to reference the current record fields using the $modeldata[my_field] variable.
But how can I reference a value that is related to another table?

I.E.:
In my form I have a select field that gets values from another table.
So, my select looks like:
OPTION 1 (value: 1)
OPTION 2 (value: 2)
... and so on.

How can I reference the "OPTION 1" value instead of the "1" value in the email?
Is there a way to query the related table and get all fields from it?
TIA
tony