Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
4 years ago

Button Formula from a checkbox field

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
------------------------------
APIs and custom code
Buttons
  • JustinTorrence's avatar
    JustinTorrence
    Qrew Cadet
    4 years ago

    @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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      Truthfully, the fastest way to check 100 checkboxes is with 100 checkboxes.  I don't think making 100 buttons would make it any faster for your users.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        4 years ago
        Totally agree. 100 buttons would end up being a terrible user experience.

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quickbase Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    4 years ago
    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
    ------------------------------
    • BethanyHudson's avatar
      BethanyHudson
      Qrew Trainee
      4 years ago
      Makes total sense! I ended up just having one check mark field, check for yes. Thank you!

      Sent from my iPhone