Add points to user when form is submitted

[Dilon_Perera]

Hi Alexandru,

You need a single relation to update current user row. You can create a Template column on your Things Table and then fill the template column clicking the three dots with User Profile>Email column.

And then add a relation column and select the the template column you created and select Users table > email. And don’t tick the multiple checkbox. It needs to be Single.

And in your form add the Increasement action and select the single relation and select the number column that created in the Users collection for the column.

Set Column Action: Alter a DIFFERENT SHEET'S VALUES!

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! [Screen Shot 2020-11-12 at 8.41.52 PM] 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!

Thank you