Button to Change Value of All Records
Hello, I want to create a button, that when clicked it will modify all data that is referenced from that table.
How do I do this?
9 replies
-
Table Make one (ex Table1)
Field Make Two (ex Text, Input)
Button Formula
let myID := number(Id);
let myIN := Input;
let x := (select Table1 where myID);
x.(Text := myIN) -
Not sure how to decode that. My main table is named "Openings" that all records are linked to. The table linked to that (that I want to change a specific field by a button is named "Application" and the field, within Application that I want to change is a choice field named 'Change Status'
-
bump
-
Bump, i still have not been able to figure this out.
-
Hi,
Please use this fortmula in the button from main table:
Category.(Choice := 2)
If this doesn't help, we should be able to help you with a consulting call, https://calendly.com/sakshi-singh-ninox/30min
Regards,
Sakshi- Ninox
-
Sakshi, I am trying to figure out your suggestion but I'm not sure if it would work for what I am trying to do.
I am trying to get a button to change a True/False field for all records in a specific table. Would that work?
-
@Halio,
use this code for that
---
let myChoice := true;
for i in select YorTableName do
i.('Yes / No' := myChoice)
end---
-
Nick, thank you so much!
this is something I'll be using in a lot of variations and situation.
i have two buttons now where one changes the hidden Edit field to true and the other one to false and the true button only shows when the edit field is false and vice versa.
-
Content aside
- 5 yrs agoLast active
- 9Replies
- 2927Views