0

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

null
    • hanimax4001
    • 5 yrs ago
    • Reported - view

    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)

    • SMoore
    • 5 yrs ago
    • Reported - view

    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'

    • SMoore
    • 5 yrs ago
    • Reported - view

    bump

    • SMoore
    • 5 yrs ago
    • Reported - view

    Bump, i still have not been able to figure this out. 

    • Sakshi_Singh
    • 5 yrs ago
    • Reported - view

    Hi, 

    Please use this fortmula in the button from main table:

    Category.(Choice := 2)

    Screen Shot 2018-08-03 at 11.15.09

    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

    • Halio
    • Halio
    • 4 yrs ago
    • Reported - view

    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?

    • Nick
    • 4 yrs ago
    • Reported - view

    @Halio,

    use this code for that

    ---

    let myChoice := true;
    for i in select YorTableName do
    i.('Yes / No' := myChoice)
    end

    ---

    • Halio
    • Halio
    • 4 yrs ago
    • Reported - view

    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.

    • Nick
    • 4 yrs ago
    • Reported - view

    👍

Content aside

  • 4 yrs agoLast active
  • 9Replies
  • 2916Views