The case is, I want to setup column Discount in User table to be filled with value Amount from Promo table. I found that there is “Set Column Values” action, but it seems like I can’t easily found a way to get the value from any table…
… is there a workaround for this?
If I’m correct you need a single relation column.
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!
You may need to “create” a relation in order to get to your User Profile table. Here’s a thread that helps explain how:
Need "Set Column > User Profile >" without template/relationToUser