I have a columns set as required but they are not appearing as such and forms are being saved with missing data, is there any reason this could be happening?
Example:
If your column has a Valid If expression, and that expression produces a list result, and the result list contains no values, this is taken to mean there are no possible valid values for the column. If there are no possible valid values, the column is not displayed in the form.
Okayโฆ
The dropdown compiles a list of user names based on the selection of trade (either Mechanical or Electrical).
The Mech/Elec field is a simple enum with no valid if expression and is a required field also.
Note the missing ** indicating it is required.
These two fields are obviously linked but I am still confused as to why its not working to be honest. Every user has a trade/type associated so there will always be a dropdown option available.
Mech
Elec
Please share your Valid If/Suggested Values formula for the Requested By
What is the key column in your Users Sheet?
Computer key which concatenates the User Name and Type.
User Name is the label for the dropdown appearance
may sound stupid but try using a formula with just True instead of the checkbox for the require field. I have found it behaves different than just the check mark in some situations.
Thanks for your suggestion! I did give this a go but it hasnt worked unfortunately
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |