Skip to main content
Question

Rich Text Button Help

  • February 4, 2021
  • 0 replies
  • 41 views
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+3
  • MattStephens
  • Quickbase Alumni
  • February 5, 2021
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
------------------------------
Terms & ConditionsAccessibility statement