How do I create a button within a Quickbase form that allows users to add fields when needed?
How can I add a button within my Quickbase form that enables users to add additional dropdown fields with associated comment text fields as needed? ------------------------------ manohar vankireddy ------------------------------
change multiple fields with one button
so I need to make my cancel button change one field to "Cancelled" (which it is doing) but now I need to get another field (fid 65) to change to "Closed" and I have tried to simply add on the field ID 65 but that hasn't worked out so well as I get an error. here is my full code w/o my app ID tho var text RID = If([Record ID#] > 0, ToText([Record ID#]), "%%rid%%"); var text Edit = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & $RID & "&apptoken=missed one &_fid_79=" & URLEncode("Cancelled") & URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & $RID & "&apptoken=missed one &_fid_65=" & URLEncode("Closed"); var text DisplayURLMissingRID = URLRoot() & "db/" & Dbid() & "?a=dr&rid="; var text URL = $Edit & "&rdr=" & URLEncode($DisplayURLMissingRID) & $RID; "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #000000; border-radius: 10px; color: #ffffff; display: inline-block; padding: 5px 5px 5px 5px; width:200px; text-align: center; text-shadow: none; border: 2px solid #000000; font-size: 12px \"href='" & $URL & "'>Cancel</a>" this is the error that I get: <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>220</rid> <num_fields_changed>0</num_fields_changed> <update_id>1680093311158</update_id> </qdbapi> so while I would guess that this change is wrong (obviously), but the ask is possible, just went down the wrong road. thank you for your help! ------------------------------ Michelle Craig ------------------------------
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 ------------------------------
JavaScript Warning, How can I get this working again?
I have a button that when clicked changes a Date/Time field (57) to when the button was clicked. I am now getting a JavaScript warning when I open the properties window of the button field. How can I get this working again? Thanks, Brian ------------------------------ Brian Dunk ------------------------------
Formula redirect that passes a dynamic value to a report?
Is it possible to pass along a value in a redirect that can be used as a filter in the report I redirect to? For example, say I click a formula rich text button, and in it is a line like this: var text url = URLRoot() & "db/" & [_DBID_GROUP_IDS] & "?a=q&qid=7&_fid_7=" & $rid; Where _fid_7 is the [related parent id], and make that report filter on [related parent id] = _fid_7? ------------------------------ Christopher Greene ------------------------------Save and Keep Working behavior in a Custom button
The native behavior of Save & Keep Working will save Both the edit made to embedded child records and whatever changes made in the form to the parent record. The code below Does Not do that. I found the below at: Alternatives to common JavaScript Insertion techniques var text rid = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%"); var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $rid; "<a class=\"Vibrant Primary SaveBeforeNavigating\" data-replaceRid=\"true\" href=\"" & $url & "\">Save & Keep Working - Rich Text</a>" My endeavor is to have a Custom Button behave the same way as the Native "Save & Keep Working" button. Save both parent and child record edits, redisplay in edit mode. Why a custom button? you may ask. Because the other options "Save & Close" and "Save & Next" I do not want to be available to the end user. Any assistance is appreciated. Thank you, CGreene ------------------------------ Christopher Greene ------------------------------
Create a simple edit record button
I am attempting to create a button to use on a table or a form to allow not so familiar users to find easily. I am using this formula "?act=API_EditRecord" in a URL-formula field but am getting an error. Is the URL-Formula field the way to go? ------------------------------ Michael Hall ------------------------------Create a simple edit record button
I am attempting to create a button to use on a table or a form to allow not so familiar users to find easily. I am using this formula "?act=API_EditRecord" in a URL-formula field but am getting an error. Is the URL-Formula field the way to go? ------------------------------ Michael Hall ------------------------------Passing field data through homepage button
I want three buttons on my homepage. Depending on the button that user selects I want the action of pushing that button to pass information to a field. Is that possible with homepage buttons? ------------------------------ NOEL HODGES ------------------------------
Formula API Button to create records in table in another app
Hello, I am creating a new app for managing travel expenses. I have a tasks table in my main ERP system that my users use. Can I create a formula rich text button in my travel expense app using formula url's to create a task in another app? I have done it within the same app many times but when I try to do it, it is not recognizing the table (presumably since it is in a different app) ------------------------------ Ivan Weiss ------------------------------
