Custom Edit Record URL for EOTI
Hello All - Here's my situation: I have a community app that captures Parents in the Parents Table (name, email, cell). I then have a Parent/Child relationship (no pun intended) to the Child table [Child 1 (name, age, dob), Child 2 (name, age, dob), Child 3 (name,age dob)]. I would like my workflow to look like this: EOTI audience visits my registration link Parent registers by entering their initial information (regular html form to parent table) Parent receives email confirmation of registration (pipeline to mail chimp) In the body of the email, there's a series of welcome text and other information. At the bottom, there will be a link that says "Click here to complete registration and add children." The link will allow them to add 1 or many records to the Child table. The only way I can think of to achieve this is to create a Pipeline: Trigger - QB Record Created Action - Outlook Email - where the body of the email contains the Add Record API URL linked to the parent record. Right now, I have constructed the URL by entering the following text in the body: https://andtechllc.quickbase.com/db/bt2mpv3zh/form?a=er&rid=Record CreatedRecord ID&rl=ct&page=1 Is this the right way to do this? If it works, I can see it working for the first child, but how do I ask them if they want to add another child? I hope this makes sense. What other information do you for me to help you help me???6Views0likes0CommentsAPI_GetUserInfo
Hello, The purpose of my pipeline is to dynamically add a user via API calls. The user who submits the request to add a "new" user has to input the "new" users email address. I understand that I then need to use that email address within the API_GetUserInfo to check if the user's email exists on any realm within Quickbase. If it does, then I should use the @id response data and insert it into API_AddUserToRole -> API_SendInvitation. If it doesn't exist, then I should use API_ProvisionUser -> API_SendInvitation. My issue is that if a user is not found within the API_GetUserInfo, it throws an error: "Quickbase reported an error: 2 : Invalid input : The user with the specified email address or username does not exist." I have tried adding an if statement to avoid the error and simply continue on: {% if b.json.qdbapi.user['@id'] != "" %} true {% endif %} However, it still throws the error if the user is not found. Is there any way to prevent this error from occurring? Thank you.34Views0likes3CommentsSave & Redirect in a Formula URL Using API_GenAddRecordForm
Hi. I have a need to "duplicate" the record and populate some fields on the new record (from the original record). It's not saving my current record before adding the new record, how do I get it to save first? I have the advanced setting turned on. This is my Formula URL Button: If( [Request] = "Include Existing Contractor + Add NEW FTE for Conversion", URLRoot() & "db/" & Dbid() & "?a=API_GenAddRecordForm" & "&_fid_53=" & URLEncode([Related Business case]) & "&_fid_129=60" & // Softcode the Months Needed to 60 FTE "&_fid_68=This Request is related to " & URLEncode([Request]) & "&_fid_123=14" & // Sets Request to "New FTE (Related Conversion)" "&_fid_127=FTE" & // New Employee Type "&_fid_43=" & URLEncode([Contractor PID - Dept]) & "&_fid_139=" & URLEncode([Related Level]) & "&_fid_138=" & URLEncode([Related Role]) & "&_fid_140=" & URLEncode([Related Hiring Manager]) & "&_fid_171=1" & // Start Date Override Checkbox to Yes "&_fid_259=" & URLEncode([Record ID#]), If( [Request] = "Add New Contractor + Add New FTE for Conversion", URLRoot() & "db/" & Dbid() & "?a=API_GenAddRecordForm" & "&_fid_53=" & URLEncode([Related Business case]) & "&_fid_129=60" & // Softcode the Months Needed to 60 FTE "&_fid_68=This Request is related to " & URLEncode([Request]) & "&_fid_123=14" & // Sets Request to "New FTE (Related Conversion)" "&_fid_127=FTE" & // New Employee Type "&_fid_84=" & URLEncode([Related Role]) & "&_fid_29=" & URLEncode([Related Level]) & "&_fid_38=" & URLEncode([Related Hiring Manager]) & "&_fid_43=" & URLEncode([New Dept1 #]) & // Dept #: sets field 195 to field F "&_fid_259=" & URLEncode([Record ID#]), "" ) )36Views0likes4CommentsWhat is the matter with my API Button formula?
Trying to create an API button to open a new record in another table (ideally will love to build this out while passing details on to specified fields. But. I can't even just get it to do a new record). What gives? I've compared this to some of my other similar records, and can't figure out why this won't work. Thanks!53Views0likes4CommentsSave 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.20Views0likes0Commentsautomate role granting process - add admin to all apps
Hi guys. I am currently working on a project thats going to automate role granting process based on the requests in ServiceNow so I am looking to utilize the HTTP API to grant user a role through API_AddUserToRole. First I want to export current roles related to all active apps in Quickbase - a whooping 429 apps to be able to create a predefined drop-down (we are currently not creating more roles/apps). I understand that through API_UserRoles call I can get all roles associated with one app, so if it means that an account with admin access on all apps can generate list of all roles for all apps. How can I streamline granting such admin access to 429 apps? Or granting some access level to all apps? Any advice or strategies would be greatly appreciated.14Views0likes0CommentsButton: save the new record and edit the new record
Hi, From the previous post (Add Save and Keep Working Button on form for a new record), Hunter provided a wonderful solution to save the new record. If going further, is it possible to edit the new record within the same URL? I tried the following, but got the error message "Missing "rid" parameter" "URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=%%rid%%" &"&_fid_20="&URLEncode("Yes"); My intention is to use one button instead of two buttons to provide the function: (1) save the current new record (2) edit this new record. Any suggestion? Thanks in advance!Solved95Views0likes6CommentsIncompatible value error
I'm using the API to create records, from time to time I get an error that says incompatible value, today I got it again: "lineErrors" => { "7" => ["Incompatible value for field with ID \"43\".", "Incompatible value for field with ID \"93\"."] } This is the record in question: {"6"=>{:value=>blah}, "11"=>{:value=>"2024-04-16T07:59:30-05:00"}, "12"=>{:value=>"2024-04-16T14:50:00-05:00"}, "13"=>{:value=>"blah"}, "24"=>{:value=>blah}, "25"=>{:value=>blah}, "43"=>{:value=>21418}, "93"=>{:value=>269}, "15"=>{:value=>11356}} There are 3 more record that are created properly, those 3 records share the same values for 93. I also check the records for the value on column 43 and all those exists. It is driving me crazy. Any idea?9Views0likes0CommentsSaved Value is not registering before redirect
I just encountered an issue I have never seen and am wondering if anyone else has come across this. I have a Formula Rich Text Button that Does the following: 'Class=Save Before Navigating' Run an API_EditRecord and set a half dozen fields. I am in Table A, and there is a record in table B being edited. The problem I am having is I will see the 'Saving' dialogue come up (indicating my record is being saved), but it doesn't always see that field was changed. Here is an example. For example, I changed a singular text field (minimally, I removed a period). The auto save ran, but then it indicated '0 fields changed'. Yet, I can see on my launch record the field is in fact saved, without the period. A field definitely changed. (I would post a picture but that seems to be bugged) This is not consistent. Sometimes I run the test and the edit is made as expected. Another time I will run the test and it doesn't register the change. It is almost as if it is a race against the clock. Sometimes the EditRecord API is running before it can tell a change was saved. Has anyone else run into this?26Views0likes3Comments