Not only can you use the new āSet Columnā action to edit a value within your sheet via button press, but now you can manipulate values in OTHER SHEETS as long as thereās a relation!
This is SUPER powerful. In my demonstration below, I take an inline list of four items and turn them into buttons that can be used to track habits in a DIFFERENT SHEET thatās associated to the currently signed in user!
Agree. I just had a use case just this morning. Previously I was not able to do this in forms because thereās no way to know what specific record the user is viewing, but here we are.
Instant draft picks for a Fantasy app, here we go!
Hey @Robert_Petitto & @ThinhDinh, great work you guys have done, really really cool stuff. These new features are so great. I have an issue with a chat that Iām creating, and I was hoping you guys could give me a hand, cus I think that the āset columnā action could help me solve the problem, hereās a small video with the issue I have. Thank you so much in advance
You can have a setup like this to make it work two ways.
Create a template column in your chat sheet, joining the two emails, letās call it āEmailsā.
So you would have something like āemail1@gmail.com,email2@gmail.comā.
Then in the same sheet create a split text column, letās call it āEmail Splitā, split the above template by the comma so you would have an array of 2 emails.
Back to your users sheet, create a relation matching the email column with the email split column in Chats sheet.
In your users sheet, create a joined list column on the relation above, returning the āEmailsā column in Chat sheet.
In your conditional visibility for the item, hide when the joined list column contains the āscreen emailā.
Then two multiple relations (solely for inline list displaying purpose) from those templates to the emails column I mentioned in the column above, in the Chats sheet.
Display the two relations in two inline lists, it will show up one only anyway, as only one of the two would match, if thereās a chat already created.
Great tip @Robert_Petitto, yesterday I tested this feature trying to find a way to clear a whole column (vĆa Clear Column parameter) but didnāt see the capability to use relations here.
But now, I found out that only Single Relations can be used into Set Column Action and Iām wondering WHY?
The perfect use case could be that: clear/write values belonging a Column ruled by a Multiple Relation
Thatās what I show in my video. Currently the increment action doesnāt reference other sheets like the set column does so youāll have to build the increment columns like I show in the video.