Just a simple relation, no look up. Essentially I want to put the current date in a field on another sheet.
Iâve added a relation column in the screenâs sheet, and a look up value but no luck. 
It doesnât have anything to do with the lookup column, make sure you are adding it on the right screen, that sources from the sheet you added the relationship.
Thanks! Figured it out with a sample app after your messages! Itâs because it doesnât show up when the relation is set to match multiple relations (which makes sense, the function wonât know which row to set).
1 Like
Actually when I saw the wording I thought it was clearing the whole column haha. Hopefully the option will be there in near future.
1 Like
Has anybody heard anything further in respect of this issue? Specifically:
âUpdate Columns action always updating the first row in the sheet when the table is accessed via a relation.â
Thanks
I do this (update columns in another sheet via a relation), and it generally seems to work.
You canât see the column thatâs being updated, as itâs lower down in the list, so youâll have to take my word that itâs there 
Although⌠I have observed one instance where the desired row wasnât updated (the first row wasnât touched either). But I havenât been able to repeat that, so not sure what happened. Iâm guessing that there is a very specific set of preconditions that causes the behaviour that youâre observing, but have no idea what they might be. Sorry I canât be more helpfulâŚ
4 Likes
Ok. Super useful. Appreciated. Iâll test my end again later today.
1 Like
I canât seem to get this to work. I think it worked at some point (I might be mistaken).
I am trying to do what @Robert_Petitto did where the list can be picked visually. In my case in challenges, if you pick a challenge, you would be able to click one of the two buttons (they do the same but I was trying two different ways)
@Sandro_BritoâŚtry this:
1 Like
Thank you Robert. I will try to implement this later
In your case youâre setting the choice per user on the profile sheet. In my case, each user will have many choices as itâs set per challenge.
Does that mean that instead of the email address I have to use the challenge ID to create a relationship?
How I am doing it in a different app is you would need to have one column per row that youâre allowing to select. So if you have an in line list of 15 challenges and youâre allowing them to select all of them, then you would need to have 15 columns in order to except those selections. Not the best development technique, but it gets the job done.
Oh, unfortunately, that doesnât work for me as each challenge is coming from another user.
Thank you, I am sure Iâll use that in some other way.
Thank you @Robert_Petitto Iâve been struggling with how to change another column sheet till I found your post.
Iâve implemented your trick to change a user-specific column when a user submits a form. It works fine but if I change to another user and then come back to the one who submitted the form the column value is lost. Any idea why does this happen?
In fact, though it seems to change the column value (Button color has changed) the item row is blank
A user specific column is exactly that. Itâs specific only to the user who filled it. If you need that column value to be visible to all users, then I wouldnât use a user specific column.
I want to use that column to filter a list of events in a form to prevent a user can register twice.
The button color changes only for the user who has registered
1 Like
Another option is to instead create a template of the user email and the event name/id in the event sheet and the form sheet. Then create a relation in the event sheet to link both templates together. Then you can show the button based on if the relation is empty or not.
But back to your issue with the user specific column not showing a value after switching to another user and back to the original user again (I may have misread your issue)âŚdoes it show up if you refresh the browser?
1 Like
Thanks for your quick response.
does it show up if you refresh the browser?
No, it doesnât . Actually this could be expected, as the item doesnât save in the table.
⌠create a template of the user email and âŚ
Thanks for the idea. Iâll try it, though it may be difficult without a user-specific column as many users can register to the same event.
Edit:
The empty relation makes the job. Thanks again
1 Like
I actually use that method quite often. The form submissions should already have the user emails submitted with the event id, so that will be easy to create. The template on the event sheet will just pull the email from the user profile. It doesnât require any user specific columns, but the email will dynamically change based on the user thatâs signed in.
3 Likes
Have you analyzed what happens when two users log in at the same time? Iâm afraid the second user may change the column in database and then the first would see he is not registered in the event.