Add New Record for a report Link

  • 0
  • 1
  • Question
  • Updated 8 months 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

  • 642 Points 500 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
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.