Add New Record for a report Link
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 ...
Forum Discussion
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.
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.
