Recent Discussions
Pipelines bug: Not able to parse JSON when JSON records path defined
Hello, I bought up this very issue 2 years ago, but it now looks like the solution is no longer working. https://community.quickbase.com/discussions/quickbase-discussions/pipelines-bug-json-value-not-being-parse-when-specifying-the-json-records-path/20129 Steps to reproduce: Insert a fetch JSON and iterate JSON steps. In the Iterate JSON step, I've defined the JSON Records Path as: /response/results. I've included an example JSON response below. Inside the Iterate JSON loop, I'm tried using the following variables to refer to the custom_id parameter: {{c.raw_record.custom_id}} {{c.raw_record.['custom_id']}} However, I keep getting this error when the pipeline is run: Validation error: Incorrect template "{{c.raw_record.custom_id }}". ValueError: invalid literal for int() with base 10: 'raw_record' This is very strange as this method to refer to a JSON path used to work perfectly. I also doubled checked the activity log and using raw_record in the variable should be correct, because when you define the JSON Records Path, Quickbase uses "raw_record" to refer the defined path as shown in the activity log for the Iterate JSON step with the records path defined. (see attached screenshot) Example JSON response { "status_code": "200", "response": { "batch_id": 123", "created_at": "1740504520", "expires_at": "1740590920", "completed_at": "1740504923", "status": "completed", "results": [ { "custom_id": "123", "result": { "text": "text", "type": "text" } }, { "custom_id": "test_0", "result": { "text": "text", "type": "text" } } ] }, "error_message": null }
Document Template Save PDF to field in Record API Pipeline
I have been wracking my head all day on this. I was reading Generate Documents from your records in your app where it says "However, you can also create API calls and use Pipelines, code pages, or custom integrations to generate documents. Each part of the formula represents an API parameter.". I was using Restful "Generate a Document" and was able to make a request: How do I get the output of making a request or basically the document template for this record as a file attachment in the record? I tried using: <qdbapi> <rid>1700</rid> <field fid="22" filename="Model_T.jpg"> Base64 encoded file content</field> Thank you so much!
Auditing field changes using Pipelines & Jinja
I'm using Pipelines to track changes on hundreds of fields in a table. The step that writes a summary of the changes to a rich text field uses Jinja that looks like this: {% set fields = [ ('Field Name 1', a.field_name_1, a.$prev.field_name_1), ('Field Name 2', a.field_name_2, a.$prev.field_name_2), ... ('Field Name 200', a.field_name_200, a.$prev.field_name_200) ] %} {% for i in fields %} {% if i[1] != i[2] %} {{'• <b><u>' ~ i[0] ~ '</u></b> changed from <b>' ~ (i[2] if i[2] is not none else '(null)') ~ '</b> to <b>' ~ (i[1] if i[1] is not none else '(null)') ~ '</b><br />'}} {% endif %} {% endfor %} It works, however I'm questioning whether this can be done more elegantly, with Jinja or otherwise. I couldn't find a way to loop over the changed fields only in a generic fashion so I constructed tuples for each field. This makes the step very lengthy and difficult to find what I need; additionally my browser becomes sluggish when working with the Pipeline. I appreciate any recommendations here.Gauge Report Reverse Goal Feature?
We are using Gauge Reports on Dashboards to act as Actionable Items for a given workflow. For example I log on to Quickbase and my Dashboard loads with a bunch of Gauge reports. If the reports show 0, I know I am done. If the reports are greater than 0, I click the report to view the records where I need to perform some process to make the report 0. The Goal is 0. I can reverse the Low and High to apply the proper color coding. I cannot set the Goal to be 0. The Goal must always be greater than the Start At value. Has anyone come up with a solution for this without building a bunch of formulas? Am I missing something in the report settings?Restful API Report digesting JSON
I really want to batch UPSERT to a unique field in Pipelines. I am using RestfulAPI to get a report ~ the data is filtered at the source. ChatGPT has shown me {{b.json.metadata.totalRecords > 0 }} is how I know my report has values. I want to iterate over the JSON, Restful API returns JSON ... I cannot select the Restful API as an input for the iterate step. Why must I add a FetchJSON step in front of the iterate step and essentially move the values from the Restful output to the fetch and then to the iterate?Ipad browser issue - Something went wrong?
All of a sudden a few of our end users are having issues with random tables and forms opening on quickbase on ipad browser. They get the Error "Something went wrong, try reloading this page." Tried resetting/deleting Clear History and Website Data from safari tried on chrome and still have the same issue. Restarted and force closed the applications as well. Tested as that user and cant replicate it. Not sure if this has to do to an iOS update or what. Anyone else seeing this? Have at least 3 users with the same issue started this week.Time Zone change
Good morning, I am building a Transportation application for my team to use. When we request a pickup time from our transportation vendor, it is always in central time since we are based in Texas. Can QB convert the central time to local time based on my selected city? For example, I have an employee who needs to be picked up at LAX at 10 a.m. Pacific time, but we can only enter 12 p.m. Central time. How can I build a formula in QB that will convert noon central to 10 AM when I select LAX as a city? The same goes for all the cities we service. How can I make sure Daylight savings are accounted for? I have attached a spreadsheet of the cities we service regarding their summer and winter times.
