Click, Add and Save

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

I created a relationship between two tables (Client list and Attendance) and on the main table (client list) it created two fields (report link and formula url). As of right now when you click on the URL button, it would take you into the Attendance form with the fields already populated. Is there a way i can tweak the formula to be able to create the record with the fields already populated and save it without leaving the main table. Below is the formula that the system begins with:

 URLRoot() & "db/" & [_DBID_GENERATION_ATTENDANCE] & "?a=API_GenAddRecordForm&_fid_7=" & URLEncode ([Record ID#])& "&z=" & Rurl()

Photo of Juan

Juan

  • 20 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Photo of Sania

Sania

  • 476 Points 250 badge 2x thumb
This page redirects to nothing, do you have an answer for this?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
I suggest that you post a new question.
Photo of Jim Harrison

Jim Harrison

  • 1,926 Points 1k badge 2x thumb
Sania, always grab the last part of an old URL "fill-out-form-with-a-click-of-a-button" and Google it. You will find the new URL.
https://community.quickbase.com/quickbase/topics/fill-out-form-with-a-click-of-a-button
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Well, I never knew that trick!