I have a question about triggering a notification based on two values values submitted with a form.
I would like to have 5 columns, each named a different color. Under each column I would like to have a list of values. (a1, a2, a3)
In a form view in app sheer I would have to have two fields for the user. The first field I would like to have the user select one of the 5 colors. Field two I would like the user to input a value.
I would like appsheet to search the column they selected to see if the value is on the list. If the value is on the list I would like appsheet to trigger a notification.
Example: user selections red column on form and inputs a value of a5. a5 is one of the values listed under the red colimn.