Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
5 years ago

Rich Text Button Help

I'm trying to create a button that will edit a field for every record on a page (Mark All Invited - for each Contact). I removed the user of a developer we no longer use, who had an app token, so I guess that's why it stopped working. I don't need to use an app token on this field though. I'm so lost.

------------------------------
Bethany Hudson
Program Administrator
Mobile Bay National Estuary Program
Mobile AL
2514598870
------------------------------
  • Hi Bethany,
    App Token's are associated to an App, but not a user. The user you removed may have been using a User Token which I don't recommend for a button in case the user gets removed (as in your case).

    I assume by every record on a page, you mean every record of a child table within a form. For that I'd recommend either that you just tick a checkbox (skip steps 2, 3 & 4), or have a button that ticks it for you:
    1. Add a field in the parent table (I'm guessing you have an events table or similar?) called "Mark All Invited"
    2. Add a formula button (I totally recommend getting the Magic Buttons app from the Quick Base App Exchange)
      "<a class='Vibrant Alert' style=\"width:310px; text-align: center;\" href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=yaaaaaaaaahhhhhhoooooooo&_fid_101=1&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "'>Mark All Invited</a>"
    3. Replace yaaaaaaaaahhhhhhoooooooo with a new App Token (App Settings > App Properties > Manage App Token)
    4. Replace 101 with the field ID of your new "Mark All Invited" field you made in step 1.

    So now you have a button that just ticks a box in your parent record (or just a tick box called called "Mark All Invited").
    Next you just need to create a QB Action that edits the related contacts.
    1. Trigger: "Mark All Invited" changes and changes to True
    2. Action: Edit Contacts, copy "Mark All Invited" to "Invited"
    That's it!

    ------------------------------
    Matt NZ
    ------------------------------