Button in form to open another form

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

How can I create Link/button in form to open another form (e.g. 19) for the same table? Thanks)

Photo of Antonina

Antonina

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Brendan

Brendan

  • 40 Points
Hi Antonina,

Here's a KB article that outlines what you described:

http://quickbase.intuit.com/developer/knowledge-base/how-can-i-create-formula-url-button-which-opens...


Let me know how it goes!
Photo of Antonina

Antonina

  • 0 Points
ooooo, I'm almost there! Just it opened the "add new form". how can I open another #19 form to edit current record I'm in?
I have now: URLRoot() & "db/" & [_DBID_THE_CORE] &"?act=API_GenAddRecordForm&_fid_xx="&[Record ID#] &"&dfid=19" &"&z=" & Rurl()
Photo of Brendan

Brendan

  • 40 Points
To go to the edit record form replace API_GenAddRecordForm above with er:

URLRoot() & "db/" & [_DBID_THE_CORE] &"?act=er&_fid_xx="&[Record ID#] &"&dfid=19" &"&z=" & Rurl()

The er stands for Edit Record.
Photo of Antonina

Antonina

  • 0 Points
hm.. it still gives me the form for add initiative and not edit the record. any ideas why?
Photo of Brendan

Brendan

  • 40 Points
Give this one a try:

 URLRoot() & "db/" & Dbid() & "?a=er&key="&[Record ID#]&"&dfid=19"

https://quickbase-community.intuit.com/questions/163652-url-formula-to-open-a-different-form
Photo of Antonina

Antonina

  • 0 Points
Great! It works! Now I'm the most powerful person in the world!! :D
Thank you very much!
I want to create a field Button that opens a form another Table. How can I do it?
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,402 Points 50k badge 2x thumb
I suggest that you post this as a new question.