I’ve seen this problem come up in a few posts, but have not seen the answer. Its simple enough - and comes down to not quite understanding how to treat data that is a reference. [Screen Shot 2020-01-31 at 5.17.07 pm] I cannot for the life of me make a formula for the button that is able to inser…

Hi @Brendan_Woithe , The main issue here is related with what Lookup() - or Filter() - formulas actually retrieve. They in fact return “one or multiple rows”, therefore a generic datatype. In order to have the single row reference, you just add the intuitively obvious, but necessary First() select…

Setting a Lookup Column via an Action (Button)

Brendan_Woithe January 31, 2020, 6:53am 2

This shows what I thought would work…

But it ends up inserting TEXT rather than the lookup (so a reference to a row - which is what i need!)

Cheers.

Odd / unexpected filter behavior

Topic		Replies	Views
Setting Values in "Add row" Button Action Suggestion Box	2	715	April 29, 2020
Newbie question on Set Value within Button to select relevant lookup value	2	321	March 13, 2021
Add new elements to the lookup column	5	389	March 31, 2022
Modify a single row by pressing a button in another table	3	1992	October 30, 2019
Use a Button in one table to add to Lookup column in another table	0	364	March 25, 2021

Setting a Lookup Column via an Action (Button)

Related Topics