This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’ve been trying to make a few changes to my app these past couple of days and it seems a few bugs have crept in
Yesterday I tried to enter a data constraint into a field but kept getting an error. however, after syncing 3-4 times it allowed me to save the formula that I knew was correct. SOLVED.
Today, I’m trying to save a key column formula as UNIQUEID() but it simply doesnt save. I update the formula, hit save, the editor reloads, but nothing is saved. I’ve tried 5+ times now and still nothing
Second column in the same table has a reference to a parent table. When I enter a new row in the app using the form, the ref to the parent ID is visible but not editable as it should be. But when I save the entry, this particular column doesn’t write onto the sheet. I checked google sheet versions - no errors - and the audit log - also no errors.
You can fix this: set the Editable? property to the expression, FALSE, instead of setting it to OFF. Confusing, but it works. Why? Because Editable? is a misnomer. When you choose ON or OFF, you’re actually choosing whether the column is read/write (ON) or read-only (OFF) for the entire app. When you set an expression, the column is made read/write for the app, but the user’s access is controlled by the expression. This then gives you the ability to prevent the user from editing a visible column value in a form, while still being able to use actions to modify the value.
Solved. Could have been an internet connection or browser issue.
Is this column set as a text type? For example if it is set a number then it would not work. Is the column set as editable? If not, it will not be able to fill in anything. You also might get a clue from the info tab. After you put in UNIQUEID() and then save and it disappears, you will probably have a yellow circle beside info. That can give a clue as to why it removed your UNIQUIEID() formula.
Is this column set to be a part of the other table? That will solve the writing issue. For the columns that show up, you will need to edit which columns are visible on that table. Go to the referenced table columns and set which values should be visible and editable.
yes it’s a text type and editable. No warning on info tab
yes it is part of the parent table. FYI I have an exactly identical third column to another parent table on the table that writes just fine to the sheet
on (1) it said that it couldn’t find [_THIS] column. But it’s not a column, its referring to the entered value in the field that I was creating the valid_if constraint for
The key is called [Request ID] and the column that doesn’t write is [Asset ID]. Table is called Transfer Requests. The column I’m trying to refer to is also called on [Asset ID] on the Asset table…
I’m not sure about network traffic… I work in Rwanda where the internet in general has certain restrictions but I don’t think the network in our office has any special restrictions or filtering. How would I find out?
I saw someone post yesterday that _THIS was not recognized by Expression Assistant when composing a Valid If expression, so unless that post yesterday was from you, at least one other person also noticed this problem. But, as you’ve seen, it was transient.
In the app editor, click on Manage along the left side, then go to the Versions tab, and expand Version History. Here is recorded each save you make from the app editor. If you click the Expand button for a particular saved version, the changes in that version are described (cryptically, but described nonetheless).
Try making your change again (only that one change!), save it, then check whether the change is captured in the version history. Take note that versions saved within the last minute may not show immediately.
You can fix this: set the Editable? property to the expression, FALSE, instead of setting it to OFF. Confusing, but it works. Why? Because Editable? is a misnomer. When you choose ON or OFF, you’re actually choosing whether the column is read/write (ON) or read-only (OFF) for the entire app. When you set an expression, the column is made read/write for the app, but the user’s access is controlled by the expression. This then gives you the ability to prevent the user from editing a visible column value in a form, while still being able to use actions to modify the value.
LinkedIn
Twitter
