We have a Timesheet form and we have used it all season, works great.
Now, all the sudden, the column titled “Client Name” is not showing.
This column is a drop-down function that Ref’s another master client spreadsheet.
When I look at the Columns under the hood, I see that it is still there, it is also still in the spreadsheet in drive, and nothing seems to be amiss. No idea why it just isn’t showing up all the sudden.
Ideas?? My staff can’t function without being able to use this. Many thanks.
I’m seeing a similar issue, a ref_rows list where a user could add an entry from within a parent form, has disappeared - but still appears in the detail view so the user has to save the parent form, go to the detail view and then click on the New link in the ref_list virtual column. Other ref lists within the same form are still showing up.
I would suspect, then, that the Valid If expression is producing an empty list. If the list is empty, that tells AppSheet there are no valid choices. If there are no valid choices to be made, and the column doesn’t already have a value, AppSheet hides the column in a form view.
By the way, [Client Name] is the key and the label and required in the Master Client list. And the expression checked out as valid. And it was working before too, which is why this is so confusing.
Wait, I don’t understand. What does the Key even have to do with it? I want it to give me a drop-down list of clients that are assigned to that employee. I thought by doing a de-ref of [_THISROW].[Employee Name] it would search that out???
And again, why would it have worked for years and just not start not working??
I agree, seems fishy.
The platform is for sure going through some changes lately. If you can post some pictures or something of both the table definitions I’m sure we can help sort out back to good.
