0
BULK Edit values with a button
I have the following Q: I have a table with yes/no field. So every record in that table has either yes or no. I sometimes need to reset all records to "no". I can do this by selecting all record and then bulk edit. This exact workflow I'd like to put on a button, but there are no macros in Ninox. I assume the only way to do this is by inserting a button, call it "reset all", and then put a formula in the "on click" field. problem is that I don't know how to construct such a formula and I googled and can't find an answer.
2 replies
-
for i in select yourtable do i.'yes/no-field' := false end
gary
-
works like a charm, thanks so much, you saved me a lot of time, well appreciated
Content aside
- 1 yr agoLast active
- 2Replies
- 140Views
-
2
Following