API_AddRecord Then Redirec To Dashboard
Greetings, I have been searching and experimenting for some time now. I have given up and decided to try posting, as everything I have found is not working so far. I have a dashboard that I would like to add a button to. The button is intended to make an API_AddRecord call and then return to the dashboard. I can get the API_AddRecord URL together and it works as intended. The desired record will be added successfully. I have the URL to bring up the dashboard as well. What I can't get to work putting them both in a formula URL that will return the page to the dashboard after the call is made. Can someone give me the structure for how this is to work? Thank you in advance for any input / direction you can provide. James
Document creation - Save PDF to field in record
Loving the new Document creation feature, but now I want to expand upon it and save the generated PDF to a file attachment field on the form. The feature just makes an API call and the PDF is returned in the response, so we should be able to build a Pipeline to iterate through the JSON response and save the PDF. I've been trying to set this up for a few days, but to no avail. Has anyone done this yet?
Strange Problem with Button to mark check box
I've used this same concept in multiple places and they work correctly. I have a couple of apps, and the current app is giving me a strange error message. I'm hoping someone can give me advice on handling this. Code from Button: var text url = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=d7s84zwcx5qf79csb72q6wrdjkd" & "&_fid_20=1" & "&rdr=" & //redirect parameter //URLEncode("https://exteriorsutah.quickbase.com/db/bug9w4puk"); URL meaning URLEncode(URLRoot()&"db/"&"bug9w4puk"&"?a=er&rid=" & [Related Invoice Header]); // Takes them to the invoice header in view mode, dr is view mode er is edit mode "<a class='Vibrant Primary' style=\"width:160px; text-align: center;\" href='" & $url & "'>Select for Pay</a>" Error code being received: <qdbapi> <errtext>Invalid request - we cannot understand the URL you specified.</errtext> <errcode>102</errcode> <errdetails>ac0fb69d-e405-9558-bc99-a5a04c6ca98e:</errdetails> </qdbapi> Thank you, Paul Elliott Exteriors Utah, LLCSave Before Navigating and API Edit Record Bug - Not bug...
I posted earlier about this and said I would update, but cannot find the original posting any more. I located what I felt was a bug, but Customer Service has stated is expected. This behavior may affect many of you, and I would be curious to know how many others have realized this is happening. When using SaveBeforeNavigating, if you have changed field values it is a random chance if the order will be: Save the Record and Grab the New Field Values or if it will be Grab Old Field Values then Save Record. Thus, you are are utilizing any changed fields (perhaps you are using an edit record api and taking the value of Field A, which was just changed), you will sometimes get the original value of Field A, and sometimes get the new value of field A. I guess both actions happen at the same time (grabbing the field values and saving the record), so it's a mini race to see which one happens first, and it switches back and forth. As they are labeling this as expected behavior, I suppose we will need to start a feedback if it is something we would like to see sequential (save then get field values). Wondering if others would be interested in this feature.
Quickbase API Connection Fails with Alteryx Gallery
Hi Community, As a part of inhouse automation that we are trying to achieve we are utilizing API capabilities of Quickbase to read/write data to QB tables via Alteryx tool. The Alteryx tool has a desktop version and gallery/server web portal. The Alteryx workflow works perfectly even now with desktop version but has starting to fail out on when ran on server portal since July4th post a MS patch to our server. Error Message: "Error Transferring data. Couldn't connect to server". Seems like the connection is failing. Not sure if any of you has encountered similar issue or would know anything about it. We are working for Alteryx support on this but meanwhile wanted to post here for inputs. Thanks in advance Paras GoyalRestful API - Update Records Question
Hello, in the documentation for the RESTful API, it states "Update can use the key field on the table, or any other supported unique field". Does anyone know what the "other supported unique field" parameters would be? Instead of using the key field, I would like to use a different unique field I have called "ShiftId", to update existing records. When utilizing this field it does not update based on that field. It just errors with; "Adding non-unique value for field with ID \"69\"." I cannot find any documentation to figure out what would make it a supported unique field. Any help is greatly appreciated. Thank you!Quickbase DBA
Hi, I have developed a project management application in Quickbase for my company. As our company continues to grow, more business units are being created, making it essential to integrate them into the application. This growth has highlighted the need to standardize our database. I am seeking guidance on Quickbase best practices for database administration. Any advice or resources would be greatly appreciated. Thank you.
Fomatting Date returned in Json Response
I followed the example listed here: How to use Pipelines to email a report at a specific time of day | Qrew Discussions (quickbase.com) However, my Json reponse includes a date. The example formats Percentage and Currency, but does anyone know the syntax need to format a date data? I need it in the MMDDYYYY format (no time stamp). Thank you. Mark
RESTful API fails to fetch values for dblink-type fields
My pipeline fetches all records in JSON format using a Post request. Response is in {"key":"value"} format, where key indicates the field name, and value indicates the value of the field. The problem occurs with the fields with 'dblink' type. Specifically, it seems like the API is unable to retrieve the values of the fields with DBLink type and returns empty value. I'm wondering if there is a way to fetch the values of 'dblink' type fields?
