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

null
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view
    for i in select yourtable do
    i.'yes/no-field' := false
    end

    gary

    • gary.1
    • 1 yr ago
    • Reported - view

    works like a charm, thanks so much, you saved me a lot of time, well appreciated