Recent Discussions
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.Move attachment to SharePoint error
I'm trying to set up a pipeline to move a file attachment to a folder in a SharePoint when a record is created. On the SharePoint step, I'm getting this error. Does anyone know what is causing this? Remote API returned authentication error: (invalid_grant) AADSTS700003: Device object was not found in the tenant
Can't Upload New Version of an Existing File
I hope that I'm completely overlooking an obvious setting; it appears that the new version of Forms no longer allows users to upload new versions of an existing file. Historically, users could enter a record in "Edit" mode, click "Choose File", then upload a new or updated version of the existing attachment. However, on the new version of Forms, users in my organization only have the ability to: Lock the current version of the File, Show Revision history of the field, or Delete the current version of the attachment There is no longer an option to "Choose File" as far as I can tell. I am referencing this guidance from Quickbase Help. Below, please see an example of the file attachment field shown in Edit Mode, and the only available edit options. If anyone has advice on how to upload a new version of an existing attachment, I would appreciate your support!Running Total
I want to get a running total of the number of rows in a report. I have a formula that is COUNT([field name]), which returns a value of 1. To get the running total value, do I have to first create a var text query on the field I am counting? var text QUERY //var text QUERY = "{fid#.}"; Is the Running Total formula: SumValues(GetRecords($QUERY),fid#)
