Forum Discussion

TaraTara's avatar
TaraTara
Qrew Member
11 years ago

A formula URL button that adds +1 to a numeric field

I need help creating a formula URL button. I have an issues/suggestions table. If a user is also having the same issue that has already been submitted I basically want to create a me too or +1 button. When the button is pushed is adds one to the value in the [Number of Votes] field. Thanks in advance for any help!

15 Replies

  • Wanted to breathe life back in the post 2 years later.  I have the above coding working perfectly, but I am curious to see if there is a way where the button/image can be clicked and the count recorded without going into the record
  • Can you explain this

    "without going into the record".

    Are you asking if the button can be clicked to edit the record without needing to log into Quick Base?

  • Thanks for the response!

    I am logged into Quick Base and on my respective "Enhancements" table in this case.  My "button" is an upvote button.  When I click on the upvote button, it edits the record, but then clicks into the record as well to see the deeper information.

    Ideally, I could click the upvote button causing the edit, yet keeping the User on that same view/report, without navigating into the record


    • AustinK's avatar
      AustinK
      Qrew Commander
      You can do this with a Formula - URL field. Make it appear as a button in the settings and add it to your report. Then when clicked on your report it will edit the associated record(whatever row in the report) and do whatever you want then reload the page and hopefully you should be at the same spot on the report.

      The post by Xavier Fan in there details how to do this. Better to link to a bunch of information than explain it here.

      https://community.quickbase.com/quickbase/topics/url-formula-to-edit-a-record-and-refresh-the-page

      I do something similar and I also wrap the whole thing in another condition so when the button is clicked once it cannot be done again on that record. It sounds like you want it to be clicked many times but this is an option for another time that you can use.