Hey guys,
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.
Does the column have a Valid If expression? Does the expression produce a list of values?
Yes!
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.
ok but why would it do that all of a sudden? And there are tons of valid options for it to choose from, so something should pop up. Iโm a bit lostโฆ
Have you tried testing the expression?
I guess it doesnโt know, but I donโt understand why not considering it has been working for, oh I donโt know, at least 2 years???
Please pretty please help us out - we need this to work. Any thoughts??
Whatโs shown if you open this?
Weird! Why would it grab [Timestamp]?
Your key column is not what you think it is?
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.
Here it is:
Please please can we make these fixes happen today gentlemen? My crew needs to record their information ASAP.
Many thanks.
And why would the key matter?
Please see screen shot above.
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.
Ok this is a screenshot of the spreadsheet that the drop-down menu is referencing.
And in the form, the Employee Name is automatically inserted, working off of the userโs email.
And here is the spreadsheet that that is referencingโฆ
So I guess I am using two expressions in that way, and one relies on the other.
Please any advise is truly appreciated. I thought nothing changes and all the sudden this is happening - still no idea why!!
Thx
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.
Hey Steve, Grant, or anyone else from Appsheet that can help.
I need to get this issue solved TODAY!!
Please please pretty please can you take a look and help me. This is absolutely imperative to our ability to function as a company.
I look forward to working with one of you on this.
Many thanks.
Maybe you are the guy for this?
@Miranda_Lubarsky I have a few minutes this morning, want to do a quick screenshare. that would be best for me. grantstead@steadglobal.com
Sure! via zoom?
sure anything, shoot it over!
Ok give me a sec, iโll see if my hubby can watch the babe, he just woke up.
@Miranda_Lubarsky Genius level fix you made there!
Iโm just glad you got it up and running.
Soโฆ case is solved?
Yes!!!
And without any work whatsoever. Just magically started working again.
This makes me a little nervous moving forward though, that other things might magically start to not work?
Thanks for all your help!
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |