Goal: I would like to select from a list of zip/postal codes in my form. (The list is 3000+ rows, entering the options through an enum data type is not an option).
Issue: Field does not display on the form when a valid if statement is applied.
I used a valid if statement, RETURN COVERAGE[POSTAL OR ZIP CODE], which initially worked, but I added valid if statements for separate fields from a different reference table, and then the Postal/Zip Code field stopped displaying on the form. I updated the valid if statement to SELECT(RETURN COVERAGE[POSTAL OR ZIP CODE], TRUE) – this worked for the other valid if statements I implemented, but the zip/postal code field still not displaying in the form. The data type is Text.
Table: RETURN COVERAGE
Column: POSTAL OR ZIP CODE
Second Goal: Once I can select the zip/postal code, I would like to look up the coordinating RETURN CARRIER from the RETURN COVERAGE table. I believe this can be achieved with a LOOKUP() formula.
Suggested values = RETURN COVERAGE[POSTAL OR ZIP CODE]
Valid IF = IN([TheNameOfTheColumnInTheForm],SELECT(RETURN COVERAGE[POSTAL OR ZIP CODE], TRUE))
Turn on Allow other values
The later is a bit strange I grant you. But it seems if you’re using a suggested list then appsheet demands that you allow the user to add new entries. But dont worry. By using the ValidIf formula, if they add a non-valid zipcode it won’t let them save.
The odd thing is when I remove the valid if statement the field does display in the form but the suggested list references a different column (TICKET URL) in the parent table, CONCIERGE.
Hi @1minManager , I came back to the app today, and your original solution worked in another child table I applied it in. The only thing that I can see differently was updating the key and label on the child table, RETURN COVERAGE, but I wasn’t tracking the other table as I was making changes so I’m not sure if that actually influenced it or not. I was able to update the column to enum to accept 1 value instead of enum list.
