From an open form I would like to put the members id in cell F2 for later use in Google script.
I cannot find an action for that, is there an other way?
From an open form I would like to put the members id in cell F2 for later use in Google script.
I cannot find an action for that, is there an other way?
you need to create a relation to the first row, and use set column action…
i.e: create a column named X, enter the value in the first row “X”, then another column let’s call it XXX, use a single value column, and copy X to all rows… then relate XXX to X… then create action to set values using that relation
???
What do you mean by “put the member’s ID in cell F2”? Do you mean when you create a new row it should be added there?
No, when I open Kalle Anka form and click Member, the value should be placed in F2.
F2 is the second row of MembersID column… you need to create a relation to that row… i showed you how to do it using X and XXX column… you type X in that row and relate column XXX to the column X
In Glide it’s actually the first row in his table.
@Ralf - here is what I would suggest.
This should give you what you want.
@Darren_Murphy is right… you can save 1 column… but when you deal with many tables and columns… is better to have some standard names and methods for easy finding and editing… also is easier to change the row, manually or dynamically… simply by placing X somewhere else instead of editing single value column in the editor… you can do that from glide app, glide editor, google sheet or google script
Thank you guys!
When you marking solution, you need to check the answer that solved your problem.
OK, I thought this was taking care of by AI!
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.