ContributionsMost RecentMost LikesSolutionsPipeline JSON Issue Hello, We are pushing information into a pipeline and the form tool is pushing all of the information that we need into the body. We are unable to then map them to the fields inside of our QB. This is how we see the data come into the "body" field: "{"triggerType":"form_submission","payload":{"name":"Email Form","siteId":"65aaab6438faa353e3c27742","data":{"Debt":"$10k - $20k","How are you paying your debt?":"Paying above the minimums","ZIP Code":"46077","Street Address":"123 Main St","City":"Indianapolis","State of residence":"Indiana","First Name":"TEST","Last Name":"TEST","Income Amount":"12300","Phone Number":"111111111111","Field 16":"1980-07-10","Email":"test@icloud.com"},"submittedAt":"2024-02-05T21:56:30.208Z","id":"65c1598e6dbf679c83687274","formId":"65ad82f306b073210dd5862d"}}" I have tried: {{a.body.payload.Data.Phone_Number}} in the field but it is not showing anything. ------------------------------ Benjamin Brooks ------------------------------ Re: Issues With New Forms ------------------------------ Benjamin Brooks ------------------------------ Issues With New Forms Hello Everyone, I have come across an issue with the new form which I am not sure how to solve. We currently have a relationship set up between 2 tables which allows for a user to select the county they live in by inputting the zip code and state, which then shows a drop-down of the counties they could live in. This works correctly on the old forms as looks like this: The field settings are setup as such: I am now transitioning over to the new form and it will not allow me to do the same thing it shows on the form: Even when i do as it tells me to and change the zip code it will not allow for the drop down. I cannot figure out what to do, please help. ------------------------------ Benjamin Brooks ------------------------------ Save and Redirect on One ButtonHello, We currently have two tables on that we have a relationship built. Tasks and Customers. On the task, we have validation built so that if the status of the task is different from the status of the client, it allows for the user to update the customer from the task form with a dropdown of options [Status Change]. I am currently attempting to create a text button that does the following: Validation is met, so [Status Change] = null Saves the task record and redirects to the customer record Validation is not met, so [Status Change] is not null Saves the current task that they are on with the information that is filled out Updates the customer record with the item from [Status Change] Redirects them back to the customer's form This is the formula that we have written: If([Status Change]=null, "<a class='Vibrant Primary' style=\"width:310px; text-align: center;\" href='" & URLRoot() & "db/" &[_DBID_xxxxxxxxxxx] & "?dfid=14&a=er" & "&key=" & [Phone Number] & "'>Save Task</a>", [Status Change]<>null, "<a class='Vibrant Danger' style=\"width:310px; text-align: center;\" href='" & URLRoot() & "db/" &[_DBID_xxxxxxxxxxx] & "?a=API_EditRecord&key=" & [Phone Number] & "&apptoken=xxxxxxxxxxxxxxxxxx&_fid_32="&[Status Change]&"&rdr=" & URLEncode(URLRoot() & "db/" &[_DBID_CUSTOMERS] & "?dfid=14&a=er" & "&key=" & [Phone Number]) & "'>Update Status and Save Task</a>") This formula is not saving the task. ------------------------------ Benjamin Brooks ------------------------------ Re: Calendar View With Date and TimeMark appreciate this greatly thank you ------------------------------ Benjamin Brooks ------------------------------ Re: Calendar View With Date and TimeYes this should work here is a screenshot of the input for reference and trying to fill in the highlighted ------------------------------ Benjamin Brooks ------------------------------ Calendar View With Date and TimeHello, I currently have a table that holds all of our tasks that is in a table-to-table relationship with our main customer table. When we create a task we have the date, time, and time of date (AM/PM) in separate inputs as the time of day input is very sluggish and not user-friendly. Where our issue comes is that we would like to put the items on a calendar view report from the task table, but we have no way to include all of the information into one field in a report formula. When I attempt to make them into a time of day formula I cannot get the [Task Date] (Date Field Type) &" "&[Task Time](Text Field)&" "&[Time of Day](Text Field) to work. We also need to add an end time which would be 30 minutes after the beginning time that we are attempting to create. Is there a way to accomplish this? ------------------------------ Benjamin Brooks ------------------------------ Cancel and redirect to a form of a record off of a add form Hello All! Its been a long day and i am stumped on a button. I have a gen add form up on the screen and I get an error and I would like a button that says error and I want that button to be pressed and it should cancel the record and then take them to a form id of the record that they were speaking to! This is what I have so far! var text URLONE = "javascript:DoSaveCancel()"; var text URLTWO = & "&NextURL=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "&dfid=14"); $URLONE & "&rdr=" &URLEncode($URLTWO) Thoughts? ------------------------------ Benjamin Brooks ------------------------------ Color Change When Button is PressedHello Everyone, I am trying to make a button that changes color when it is clicked from white as default to blue. It will also select the item in the multi-select text in the fid 144 to IEP. Then redirect back to the record in edit mode. I am missing something here and i cannot figure it out. I am using a rich text formula field. var text URLONE = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_144=IEP"; var text URL = "javascript:" & "$.get('" & $URLONE & "',function(){" & "location.reload(true);" & "});" & "void(0);"; If(ToText([Benefit Period])="IEP", "<a class='Vibrant Snowy'IEP</a>", "<a class='Vibrant Primary' style='border:1px solid #6BBD57; background-color:#6BBD57'" & "a href=" & $URL & ">IEP/a>") ------------------------------ Benjamin Brooks ------------------------------ Response for true or falseHello! I am working in pipelines and I send a PUT request with JSON body to a webhook in Quickbase pipeline. The webhook is not detecting my JSON variables in the body. It seems to be proper JSON but the webhook is not detecting them. I am also trying to send a response from the webhook to the web server that sent the request but the body to the response is not sending correctly so the response comes back blank everytime. Any help would be appreciated! ------------------------------ Benjamin Brooks ------------------------------