ContributionsMost RecentMost LikesSolutionsRe: API AddRecord - Error Code 50 ...wow... I can't believe I ended up pushing this to the community - usually I would have found that by now LOL It's the double ampersands - you just helped me very much, and I feel like a noob. Thank you so much, Mark! ------------------------------ Adam Kirchhoff ------------------------------ API AddRecord - Error Code 50 Wondering if anyone has run into anything similar - I want to add an API AddRecord with a Formula URL that would eventually copy some information. I was getting no errors, nothing, and eventually started stripping the formula down to the minimum requirements. With only the three required fields, I started getting error code 50, specifically mentioning one of the three fields <qdbapi> <action>API_AddRecord</action> <errcode>50</errcode> <errtext>Missing required value</errtext> <errdetail>Sorry, you did not supply a value for the required field named "Payment Source" with field id 46. Please provide a non-blank value for this field.</errdetail> </qdbapi> This is despite the fact fid 46 does have a value URLRoot() & "db/" & [_DBID_runs] & "?act=API_AddRecord&apptoken=REPLACED-FOR-SECURITY" & "_fid_199=" & URLEncode("Accept") & "_fid_70=" & URLEncode("Coding") & "_fid_46=" & URLEncode("NOT KNOWN") & "&z=" & Rurl() Just to test - I disabled the requirement for fid 46 and removed that section of the post. Goes through without a problem. Now I return 46 to required, add back into my call - back to error code 50. Is there something I'm missing? Anyone else have a similar issue? I'd hate to remove a required field attribute because one API didn't like it - HAS to be something wrong here. ------------------------------ Adam Kirchhoff ------------------------------ Re: Query Syntax difference between .EX. and .TV.Mark, I believe this is to reference the index / ID# of a lookup field. EX would match the input value, TV would match the numeric reference value of a searched proxy field ------------------------------ Adam Kirchhoff ------------------------------ Re: Using HTML in Formula - Rich Text FieldsOr if you wish to use fields, or concatenate text with field (to clarify) "<p style=font-size:14pt;color:red;>"& "Total Due: "&[Total Due]& "</p>" ------------------------------ Adam Kirchhoff ------------------------------ Re: Using HTML in Formula - Rich Text FieldsAnother method that I have been using recently is to add all your HTML in quotations by themselves. Or to rephrase, add your HTML between quotations and end with an ampersand ("<HTML HERE>"&) For example: If you were using the following: <p style=font-size:14pt;color:red;> Example Text </p> I will use in Formula Rich Text as follows: "<p style=font-size:14pt;color:red;>"& "Example Text"& "</p>" ------------------------------ Adam Kirchhoff ------------------------------