I have a form screen linked to a table which has fields with relations to other tables.
I am trying to hide a field based on the value of one of the columns however, I am assuming this is not possible as the records hasn’t actually been written to the table yet.
What do I need to do in order to have someone select a name, add that row and then hide/show the remaining fields on the form depending on the information I pull back in the relation?
I have a person table and a scores table. The person table states whether they are playing in the league. the Score table has a relation column that populates from the league column (yes/no). In the form screen linked to the scores table, I am trying to hide another field if the “league” value is “no”.
Do I need to write information to the row first in order to make the filter logic work?
In some cases, people will have entry components in their form write certain values directly to the user profile so they can immediately use the value for a relation or some other computed column, and then immediately have access to the resulting value in their form.
In other case, people will create a custom form instead of using a native form. Personally I prefer this method, and I like to have a separate single row table to serve as placeholder for form values that will be written to a different table when the form is submitted. It’s more initial setup, but a lot more flexible than a native form since every entry is being written to the table in real time.
You are correct. With a native form, nothing is written to the table until the form is submitted. Because of that, computed columns will not return any values. That’s why you need to utilize the user profile or create a custom form instead.