Skip to main content
Question

Button Formula from a checkbox field

  • April 15, 2021
  • 0 replies
  • 82 views

I'm wanting to create buttons for checkbox fields. Basically, there are about 100 fields that will either be a yes or no, so I want a button that's green and when you click it, it makes that field a Yes. And if it's not clicked, then it shows up as a No. I originally had all my fields as Multiple Choice with Yes and No as options, but then I changed those to two separate fields (ie. "Access Yes" "Access No"). I'm just wanting the data entry easy for an employee who will be using the app.

------------------------------
Bethany Hudson
Program Administrator
Mobile Bay National Estuary Program
Mobile AL
2514598870
------------------------------
This topic has been closed for replies.

@Bethany Hudson

Check out the Magic Buttons - Having fun with formula URLs app on the exchange, there are a lot of different options for what you are trying to accomplish, and all of the formulas are available for you directly in the app settings. Most of these will expend an API call if that is something you are concerned with. Here is a demo:

​



------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------

Forum|alt.badge.img+14
Agree with Mark. The biggest issue with buttons are every click refreshes the page. It's not like you can just click click click. It would be click, wait, page refreshes, get back to the spot you were at, click, do it all over again.

If you go forward, you'll want a formula rich text field. I can post (or Mark can since he taught me everything I know!) a snip of code if you decide to pursue.

------------------------------
Mike Tamoush
------------------------------