Quickbase Discussions
A forum for Qrew members of all levels, where questions about Quickbase can be asked and answered.
Links Banner
Main Content
Recent Discussions
Compile a custom raw bulk api string based off a bulk event trigger
I am attempting to store changes from a table to a dedicated "change records" table. There are a handful of specific fields I want to store changes for and I need to store both the new and previous values in these fields. So I have some complex filtering logic that can't be captured in the initial filter. At the same time, the source table can have hundreds or even thousands of records changed simultaneously or near-simultaneously, so I can't be making separate API calls for each change record to be created. And I need to be able to conditionally store a payload if the bulk creation step fails, so that I can rerun it manually/by another scheduled process. The native Bulk Upsert step does not allow for this if I'm not mistaken. For these reasons, I would like to trigger my pipeline off a bulk event, skip the default For pipeline step, and put all my filtering logic within a loop in my jinja expression for my (QB channel) Make Request step. I feel like this should be possible but I'm getting responses saying my record payload is empty. Is there a problem with the way I'm trying to access the bulk event data, or is this just not possible? { "to": "bqxxxxxx", "data": [ {% ns namespace(record_count=0) %} {% for row in a.records %} {% if complex_filter_logic_here(r) %} {% if ns.record_count > 0 %},{% endif %} { "6": { "value": "{{ r['value_1'] }}" }, "7": { "value": "{{ r['value_2'] }}" }, "10": { "value": "{{ r['value_3'] }}" } } {% set ns.record_count = ns.record_count + 1 %} {% endif %} {% endfor %} ], "mergeFieldId": 10 }Solved47Views0likes3CommentsSkipped because set values are the same as in source object.(Error in Pipeline)
I have a pipeline which is supposed to update kanban columns. Am doing a search in the first step which has the filters and then a condition to check if a condition is met with the criteria I have set. When I run it I can see the green tick which make me smile but when I go to the kanban report there is nothing happening. The only message being displayed is " Skipped because set values are the same as in source object." I've tried even creating a datetime field to use to update the search and update but nothing works. Any remedy for this?Solved44Views1like3CommentsQuery giving values of zero
What's wrong with this query format. I have checked all the values and I should be getting values other than zero. SumValues(GetRecords("{80.EX.'"&[Concate Distance]&"'}and{47.EX.'Shipping'}and {66.XEX.0}",[_DBID_DISTANCES]),66) If I don't have the "and' filters QB gives me the error"Uh-Oh! The way this formula is built will take too long to process. Please try refining your formula."Solved62Views0likes3Comments
Save and New Button on Legacy form
I'm trying to build what I thought would be a simple button for saving the current child record and adding a new one to the same parent record. I'm essentially just trying to duplicate the native Save & New button so I can place it next to the native Save and Close button. Will I need a code page for this? I have programs that have many program charges and the Users want separate buttons for adding additional records and saving the record when done adding multiple charges. FID_6 is the related Program RID in the child table, Program Charges. Any thoughts would be appreciated!Solved74Views0likes7Comments
Inspection Sheet Possibilities
I am attempting to build an inspection sheet that will state if the dimension entered is within the specified tolerance. I have attached a screenshot of how I would like it to function, however after a week of reading the community pages. I have had little success in making it operational. Current Setup(see attached): Column #1 (Data Entry-Multi Choice or Numeric). Column #2 (output based on Column #1, OK/Green, Out of Tolerance/Red) Column#3 (Section view, visual reference only) I have had varied success with Column #2 as Text-Formula or Rich Text Formula using If statements with Greater Than, Less Than, and Equal to statements. ie. it does something but not the desired outcome. Questions: Is my idea possible? If so, Is Numeric/Multi Choice the correct choice for Column #1? Am I missing a step where I need to change the numeric into text and then apply the formula? Any help or ideas on how to accomplish this would be greatly appreciated. Regards, LandonSolved97Views0likes7Comments
Required Field Default Lookups SSN
how would i make a fake social security number when the data entry doesn't have it at the time? it would need to lookup in the SSN field for 999-99-9999 999-99-9998 999-99-9997 etc. and the next auto entry would be 999-99-9996. I could create a table with all the possible values or maybe there's a formula to use somehow?Solved36Views0likes2CommentsIdentifying differences in a copy app?
As a solo developer often tasked with taking over ongoing projects in various stages of completion with either poor documentation or none at all, I spend a lot of time comparing copy apps with their originals to find the differences in order to inform how to proceed with a project. Is there a way that I'm missing to not have to do this manually? For even a moderately sized app it is extremely time-consuming to have to check every single field, pipeline, etc in two places to see if they differ. I don't need to see how they differ (manual review for that is reasonable), just whether they do. Essentially just a list of elements modified/created/deleted since the copy app was created is what I'm looking for. Is there a way to obtain this info?Solved66Views0likes2CommentsDynamic Reminder: Recipients Based on Field Value
I’m setting up a 60-day reminder in Quickbase with additional conditions, but I need the email recipients to vary depending on the value in the “Short Title” field. For example: • If “Short Title” = HYHOPE → users A, B, and C should receive the reminder • If “Short Title” = RTOG 920 → users B, D, and F should receive the reminder There are many possible “Short Title” values, so creating a separate reminder for each one isn’t realistic or maintainable. Is there a way to dynamically assign reminder recipients based on field values like this without building a separate reminder for each case? (see screenshot). I’m worried this may require using Pipelines. I’ve tried Pipelines before for other things and haven’t been able to get them to work reliably or accurately, so I’m hoping there might be a simpler or native approach within reminders or formulas before going down that route. Or, if Pipelines is the best option here, I’d really appreciate a step-by-step example of how to build it for this use case. Thank you!Solved68Views1like3CommentsQR Codes
Trying to get a qr code to print on a 4x6 label and I am using Exact Forms Plus and I have the following formula in my purchase order table under QR Code: "<img src=\"https://quickchart.io/qr?&size=150x150&text=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "\" />" No matter how I have that formatted it does NOT change the size of the qr code as shown in the attached picture. Using that formula, the qr code does scan to the correct information. I had found a format on one of the help tutorials telling me that I needed to use this code in my template: ~=barcode(f[227],qrcode,150x150)~ When I use that field in my template, it works perfectly and I can get the qr code to resize just the way I need it to at whatever size, BUT The code no longer scans. It comes up to a google page searching for F(227).Solved87Views1like6CommentsReport Dynamic filters
I have this multiple choice field which I am using as dynamic filter in a summary report but it still doesn't work because when I click it the summary report it spins and then displays empty records and then reloads all the data without filtering. How can I go about it to make a field to use as dynamic filter.Solved57Views0likes3Comments
