Form that had a select field populated by a field in 1 table that updates a field in another table

Use the name of the selectedRow in the second table,
for example:
{{nameofSecondTable.selectedRow.rehab_area_column_name}} as the default value for the Rehab area field in the form.

Though, what I would do is just make one form and have all of the data within the fields as needed to be selected or be selected depending on what is selected before them

For example
Properties fields
Selected dropdown for Property name will then trigger the next select field to be populated with options for Rehab area....and so on....

1 Like