Forum Discussion

ChrisPhair's avatar
ChrisPhair
Qrew Member
9 years ago

Help with URL Button formula to select from multiple choice field

Hi,  I have put the below URL formula in a button. The objective is to create a new record and populate field ID 31 (this is a multiple choice field) with "Daily Cost".  URLRoot() & "db/" & [_DBID...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
you need to have the fid of the [Related Parent] so the [Record ID#] can be written to that field in the new form.

You might have deleted something when you modified the button, but here is a clean example.

URLRoot() & "db/" & [_DBID_NEWITEMS] & "?a=API_GenAddRecordForm&_fid_8=" & URLEncode ([Record ID#])& "&_fid_32=" & URLEncode ("Daily Cost")& "&z=" & Rurl()

where fid_8 is the field ID on the NewItem table called [Related XXXXXX]