URL Add Related Form (But popup like embedded Reports)
I am trying to make a URL Button to add a child record in a form Example: URLRoot() & "db/" & DBID & "?a=API_GenAddRecordForm&_fid_13=" & ToText([Record ID#])& "&dfid=10&popup=1" I also tried: URLRoot() & "db/" & DBID & "?a=API_GenAddRecordForm&_fid_13=" & [Record ID#] & "&target=popup&popupwidth=500&popupheight=400" I also tried these checking In Same Page, In New Window, And In Pop Up.but the button does not pop up like the embedded report. is it possible to make a button that works this way on PC and Mobile as it does in the Report button Link?Date/Time Stamp Formula
Hello! I am attempting to track when our leads are converted, which happens when our [Account Status] field switches from "Lead" to "Signed Customer." When I created a date/time field using the formula below, it is literally continuously updating to show the current time. My goal is to just capture the date/time of when the [Account Status] field switched from "Lead" to "Signed Customer." Help? If([Account Status]="Signed Customer", Now(),null) Thank you!! ------------------------------ Rikki Ryan ------------------------------
Time Input forumula
For some reason, my users are NOT fans of inputting time values on the mobile app (brings up the pop up with the dailer style window). Is there some way that I have have them input say 2 fields (number or text whichever works) as follows... Time: Am / Pm 24 Hour time: (this is where I will need help with a formula to calculate the correct time from the two above fields). Any help appreciated. Cheers, Damien ------------------------------ damien page ------------------------------There was an error copying the records. Contact the application administrator with the error details below. Error Details: CopyMasterDetail does not allow looping relationships
I created a copy of an app as a "demonstration/test". In it, I enabled a button to Copy Master & Detail Records. It worked perfectly in the "demonstration/test" environment, but not in the live app and I'm not sure what I need to look to so that I can correct it. From what I can tell, all relationships look to be the same. One thing that was weird was when Choosing a Table in the Copy Master & Detail Records, one table was available in one, but not available in the other. I have a table called ACME (parent). That's related to another table called ACME Registrations (child). I want to copy an ACME and include all their registrations. It worked in the test. When I set it up in the test, the ACME Registrations table was not available to select. But the button worked perfectly. When I set it up in the live application, ACME Registrations was an option to select. The button was still created, but when I hit it, I get the error mentioned in the subject. Here's the button formula from the one that produces the error: "javascript:void(copyMasterDetailButtonHandler('©Fid=6&destrid=0&sourcerid=" & [Record ID#] & "', 'bsixb4euj'))" Here's the button formula from the one that does not produce an error: "javascript:void(copyMasterDetailButtonHandler('©Fid=6&destrid=0&sourcerid=" & [Record ID#] & "', 'bsyeqwhs6'))" Any help would be greatly appreciated. ------------------------------ Dominic Rodriguez ------------------------------Formula URL error
Trying to change the value of a multiple choice field using formula URL for a different Record ID getting following error This XML file does not appear to have any style information associated with it. The document tree is shown below. <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>215</rid> <num_fields_changed>0</num_fields_changed> <update_id>1675336884376</update_id> </qdbapi> URLRoot()&"db/"&[_DBID_TASKS]&"?a=API_EditRecord&rid="& [Successor Task Record ID] &"&apptoken=***********************&_fid_57= In Progress" ------------------------------ Neha Raghav ------------------------------Summary multi text field to be used as Record ID in Formula URL
Hi, I have a multi text field having the record ID of next task on my list of tasks in a table I need to pick this record ID to be used in Formula URL in order to change the Task Status field of the target record. Is it feasible? URLRoot()&"db/"&[TARGET TABLE ALIAS]"&"?a=API_EditRecord&rid="& [multi-text summary field] &"&apptoken=*******************&_fid_57= In Progress" ------------------------------ Neha Raghav ------------------------------
Report Formula: Sum total
Hi, I have two columns Erect Hours and Total Pieces Erect. This is what I want to get at using report formula; (Sum of Total Erect Hours * 60) / Sum of Total Pieces Erect. (64102.36*60)/352507.5 = 10.91 I tried using this Sum([Build - Erect Hours])*60/Sum([Build - Total Pieces Erect]). However, it is not calculating the column total but it is calculating row total. Any help will be appreciated. ------------------------------ Bibhav Rimal ------------------------------
How to show date and timestamp in formula field
I'm adding two fields, one field is having Date and Timestamp and another field is Duration of days. the output I want is Date/Time. Output field type is Date/Time ToDate([Request Received Date]) + Days([TAT]) Using above formula I'm getting the output in Date format, But I required in Date/ Timestamp ------------------------------ manohar vankireddy ------------------------------
Formula Fields no longer showing errors??!
My formula fields no longer show errors. I can type in a wrong field name with no issues, or make the syntax wrong. It wont tell me until I try to save. Are others having this same issue? ------------------------------ Mike Tamoush ------------------------------
