Add New Record for a report Link

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • In Progress
Step 1:  I have a table called routine maintenance and another table called service orders.  Basically, if a discrepancy is found during a routine maintenance visit it is noted & automatically pulled to a discrepancy report (report link).  I would like to add a button to this report that says "Create Service Order".  When this button it pressed it will open a new service order on the service order table.  

Now I think step 1 will be pretty easy.  BUT step 2 of my wants might be a little more difficult.  In a perfect world, I would like for certain information from the discrepancy report to auto-populated in my service order.  Is this possible?
Photo of Amber Polston

Amber Polston

  • 310 Points 250 badge 2x thumb

Posted 4 weeks ago

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

QuickBaseCoach App Dev./Training, Champion

  • 57,468 Points 50k badge 2x thumb
no problem,
You can populate any field you like.

urlroot() & "db/" & [_DBID_SERVICE ORDERS] & "?act=GenAddRecordForm"

& "&_fid_111=" & urlencode(field source 1])
& "&_fid_222=" & urlencode(field source 2])

You will need to get the correct table name for the service orders table from the Advanced Properties tab for the service orders table.

and the 111 and 222 are place holder for the field ID's of the field to be populated.

If the value you are putting into those fields might contain spaces or special characters, then you will need to urlencode the contents.

I have put an app in the Exchange called Formula URLs for Dummies.  It explains the some of the URL formula syntax.