Hello! I have an issue. I’ve made a community rental availability calendar with 2 types of users. Admins, and users. Users can see their own entries of people that rent their home and Admin’s are supossed to see all entries. I did this by setting 2 row owners in a column.
One is a row owner, user specific e-mail. So e-mail of signed in user gets written to the column. Second is that I set a second row owned text column. When people fill out the form, they automatically write “Admin” in that table, so both the user specific person, and all the admin’s are owners of that entry. With that, in the same way I have a few more details automatically written like a date/time and date timestamp for some filtering.
That worked perfect until I upgraded the account yesterday to the maker plan, since we want to launch it for their community upcomming Monday. The problem is now that the additional information does not get automatically written into the columns. Where I have the text entry add “Admin” now I see someone’s e-mail being written there, and in the timestamp boxes there is nothing written it all. It seems the program thinks if empty → add e-mail, but it shouldn’t be empty.
That’s weird. Even weirder that the emails in the 1st and 5th rows are not the same. Please check using “Find uses” to see all actions writing to that column.
The problem seems to be consistent and random, whenever the form gets filled out, it either adds “admin” to the column, which is supossed to, or it adds the user e-mail. Happening from both Admin, as from normal users accounts. When the e-mail gets written other information that automatically needs to write, Like the number and letter after (to refer to the house number and to a blokw here they’re located, either A, B or C)
With that, the timestamp of the entry is not writting at all. Not wrong, just does not exist.
I’m not sure what I should do. In the user tab I’ve not selected any row owners, I did that through visibility features. The way it’s setup the Admins can look at all the accounts in total through a user tab, while Users do not have those rights at all. Though I set up a visibility → if admin, for the user profiles, even if they can glitch through there they’ll only see their own account and not the data of the 200 other users. If I switch the e-mail to row owner in the User tab the Admins can only few their own account in the way it’s setup now, not sure to go about switching that back up and fixing it with the same result I have now.
The main problem I’m facing now is just the confusion of why it gets written in way A one time and switches to B another time, without a seemingly good reason
Is this really a user specific column , or are you just saying user specific because the signed in user’s email is placed in this column? You haven’t shown the heading for this column in any screenshots, so I can’t tell.
ImIn another screenshot, why is this empty? You mentioned filling the email address, but it looks like you aren’t filling it.
Are you attempting to add additional values through an On Submit action after a form submit? If so, I would recommend against that. If the timing doesn’t work out precisely, you may be attempting to change values in a row before it has been completely added to the table.
You can add all of those additional details as Value, Special Value, and User Profile components directly to the form. That way the values are set when the row is added…not after the row is added.
Not quite…The submit button adds the row, whereas ‘On Submit’ actions are executed immediately after the submit button is pressed.
The problem is that a Set Column action On Submit may be trying to edit a row that hasn’t completely been added yet, so essentially your on submit actions can fail if there is no row to update. Sometimes it works and sometimes it doesn’t, but we are taking about a split second different in processing times.
By adding the appropriate value components to the form and not using ‘On Submit’, you are doing the adding and updating in one process instead of two.
