I have a feeling I'm overlooking something simple. I'm trying to use API_GenAddRecordForm and it is working, except it isn't assigning the [Company Name] field. This field is a lookup field (in the Companies table).
I'm using this formula. I've double checked the field ID's. Field 14 is set correctly, but my company name field is not. Is there something special needed for these types of fields? Am I overlooking something simple?
URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?a=API_GenAddRecordForm&_fid_33=" & URLEncode ([Company Name])& "&_fid_14=" & URLEncode ("O1 - New")