ContributionsMost RecentMost LikesSolutionsValidation error: Invalid literal for Decimal:I am trying to export text from a related field (the reference field) in one form to a related field (also reference) in a new record using the same form, essentially creating a copy of the form and pre-filling a few fields based on lookups. Is this simply not possible with a pipeline or is there a workaround I might be able to use? ------------------------------ Dante Tognoli ------------------------------Re: No "connect to" button in pipelines channels?Great, thanks! ------------------------------ Dante Tognoli ------------------------------ No "connect to" button in pipelines channels?I'm trying to connect to outlook for a pipeline I would like to set up, but when I expand outlook (or any channel) there is no connect button on the page. Is this an account limitation I need to have fixed? ------------------------------ Dante Tognoli ------------------------------ Re: Summarize summary tables?Found the max function in the formula builder :) ------------------------------ Dante Tognoli ------------------------------ Summarize summary tables?I have a group of summary date fields of which I would like to select the most recent date and use that in a formula. I can't seem to find any functions that can compare a bunch of dates and choose the most recent. ------------------------------ Dante Tognoli ------------------------------ Re: URL button not savingGotcha, so there is no record # yet and the save dialogue is trying to save the record I am currently looking at and run the URL button at the same time (essentialy) ------------------------------ Dante Tognoli ------------------------------ Re: URL button not savingI understand that part. I don't understand why it doesn't work when the system dialogue is saving it first (or perhaps it is not?) and then running the button. When I click my URL button it says "You've made changes to this Record. Do you want to save these changes before going to the next screen?". When I hit save I get the error. If it is saving first, shouldn't the record exist? ------------------------------ Dante Tognoli ------------------------------ URL button not savingI am using a URL button to edit part of a record I am currently working on. If I don't save first and I press the button, QB initiates the save dialogue on it's own but then gives me the following error after I tell it to save: <qdbapi> <action>API_EditRecord</action> <errcode>30</errcode> <errtext>No such record</errtext> <errdetail>Missing "rid" parameter.</errdetail> </qdbapi> If I save the record first using the built in save button on the form my URL button works just fine. I don't understand why the auto-save feature is throwing the error. URL button is as follows: URLRoot() & "db/" & [_DBID_FLIGHT__DUTY_AND_REST] & "?a=API_EditRecord&rid=" & URLEncode ([Record ID#])//& "&z=" & Rurl() & "&_fid_370=" & Now() & "&_fid_269=VALID SIGNATURE" & "&_fid_376=" & [Pilot Initials] & " " & Now() & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_FLIGHT__DUTY_AND_REST] & "?a=dr&rid=" & URLEncode ([Record ID#]) ------------------------------ Dante Tognoli ------------------------------ Re: API_GenAddRecordFormThanks, That did not work, but I think I left out some critical information which explains it. The field is actually a related record and the proxy field is a user field. I am using related records because I also need to look up some other fields from the parent table based on user name. ------------------------------ Dante Tognoli ------------------------------ API_GenAddRecordFormI would like to autofill the current user into a user field on a new form using the GenAddRecordForm function but I can't find a command to do that. Is there a way to do so? I am using the URL field below: URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm" & "&_fid_14=" & User() & "&_fid_18=" & URLEncode([Event ID]) ------------------------------ Dante Tognoli ------------------------------