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