Forum Discussion

EndyLu's avatar
EndyLu
Qrew Trainee
5 years ago

Button that can change a field and then go to edit mode

I have a declined button where when you press it the status will be set to declined. However, I put in a rule where a status cant be declined without a decline reason. Currently, when the button is pr...
Button
roles and permissions
EricMohlman's avatar
EricMohlman
Quickbase Staff
5 years ago
I taught how to do that specific thing at our Empower user conference this year.

The recording from the session can be found here: https://university.quickbase.com/empower2019-course/342287 and the application I taught from exists in the Exchange here:https://team.quickbase.com/db/main?a=AppDetail&ID=3795&app_name=EMPOWER2019:%20Advanced%20Formulas (replace your account URL instead of the team.quickbase.com portion)

Here's the formula I utilize in that session:

URLRoot() &

  "db/" &

  Dbid() &

  "?a=API_EditRecord&apptoken=c3f3znbrgaavayvp95cc53c2fs&rid=" &

  [Record ID#] &

  "&_fid_9=Rejected&_fid_20=" &

  Now() &

  "&_fid_40=" & UserToEmail([Approver]) &

  "&rdr=" &

    URLEncode(

      URLRoot() &

      "db/" &

      Dbid() &

      "?a=er&rid=" &

      [Record ID#] &

      "&dfid=12&nextURL=" &

      URLEncode(

        URLRoot() &

        "db/" &

        AppID()

      )

    )

------------------------------
Eric Mohlman
------------------------------