I recently deployed an app with 10 users and I’m facing an issue after launch. I have a table called Quotes, in which there’s a column called Sales rep with type “ref” and initial value USEREMAIL() and not editable. The Sales rep column is referenced to another table called User Management.
Problem is that when a user opens the Quotes form and fills out the information, even though before saving the form in the Sales rep field her name appears correctly, after saving the form (weirdly) another user’s name (email) is saved in the field.
Interestingly, in the last modified field the name of the correct user is recorded but in the Sale rep field another user is saved. I should mention that it doesn’t happen every time. On some occasions the form is saved just correctly.
Could this be just a bug?
I have 17 tables with 14 users on this app. Could it be that it’s too much data for an Appsheet app to handle?
Your feedback is appreciated.
You may want to mention what is the key column and label column of the “User Management” table and confirm the type of [Sales Rep] column in the “Quotes” table is “ref” type.
Hi Suvrutt_Gurjar
The key column for “User Management” table is the [Email] column and [_ComputedName] column (First name and last name) is its label. In “Quotes” table, [Sales Rep] column type is ref with “User Management” table as its source table.
Thank you,
If you check the data source, does it save the correct email address? If you are using gSheets, you are able to see that cell’s history was it first saved properly and then changed.
We are using Google Workspace and that was the first thing that I checked. Data seems fine. All the email addresses correspond to the correct names.
But when the user fills the data in Quotes table, the email address is saved to the gSheet wrongly?
Exactly! So I have a row in the table in which the last modified column is “Date_Time by correct users’s email” but the Sales Rep column with initial value USEREMAIL() populated by another random user’s email address. Please note that I have made the the Sales rep column “not Editable”.
What does the cell history show?
1 Like
Hi Aleksi
Unfortunately there are only 2 archived versions of the table for the whole day and I don’t find a version in which the wrong email address was captured. We edited the Sales rep column after we it was wrongly saved and I don’t see the version before the edit in the version history.
Do you have any automation bots? Or does the Save form action trigger any other actions? It seems you may have something like ANY(SELECT(UserManagement[EMail], …)) (or any number of variants of this logic) somewhere where the email is getting updated with a random value.
I’m not discussing about the version history. If you know the row where the email was wrong, right click the cell where the email is saved, and open the “Edit history”. From there you are able to see when it was originally filled by the app and what has happened after that.
1 Like
No automation bots has been implemented, neither any action on save. Also, I’m simply using USEREMAIL() as initial value for the [Sales rep] column. No ANY(SELECT()) has been used.
Yes, I can see in the cell history that initially the wrong (random user’s) email address was added and then I have to manually edit it. I put the screen shots here for your reference.
This sounds very weird, never seen this kind of behavior.
If you check from the Audit history with that timestamp you found from the cell history (remember it shows the time with your timezone), what does it show as the email address and who was the user who made it? They should match, but it’s good to double-check.
