Forum Widgets
Recent Discussions
Bulk upsert field limit in pipeline
Hi, I have a pipeline that I'm using the bulk upsert steps for. Essentially, I'm just copying data from one table to another table and I need to do this bi-weekly. It's my first time using this bulk upsert and now I see there is a 250 field limit. Is there any way around this limit? I checked online and the solution seems to be to using a helper table, I'm not sure how to do this. I only have about 400 fields so I don't want to do that if unnecessary. I also saw something about a loop but I don't know how to do this either. What's the best way to go about this? I have the following steps in my pipeline: Prepare bulk record upsert Search Records In Loop: Add a bulk upsert row - End loop Commit upsertSolved0likes6Comments
'Equal to' 'Not Equal to" not opposites
I am trying to filter a report and am struggling to get the inverse of the if/then to show properly. I have tested the 'equal to' formula and it is working properly. i.e. I set a filter to be equal to that word so it only pulls records with that word in the field I am referencing. However, if I want the inverse of that report. i.e. I want all the records that do not contain that word to pull on the report however the inverse which I believe should just be switching the 'equal to' to 'not equal to' is not filtering the report at all. even though I have told the report to show me words not equal to the value I've entered are still pulling to the report. I can make a work around with multiple 'equal to' lines. I just believe that selecting the inverse of equal to should pull the records properly. TIA, KbarrySolved0likes4CommentsNew Style Forms in Mobile - native Save button keeps user on Add Record form
Has anyone else run into this issue? We created a new style form for desktop and applied it to mobile as well. On desktop, when a user saves a new record by selecting the "Save" option (not Save and new or any of the other available options), they will re-direct as normal. But on mobile, when the user clicks the native save button that follows them down the form, the record saves, a "record saved" message briefly shows at the top of the screen, and then the user remains on the Add Record page with all of the information they just recorded. If you do not notice the message that flashes on and disappears from the screen, it appears as though no action occurred, which naturally makes a User want to click the save button again. This is causing many duplicate records to be created and causing confusion for users as they are unsure with what to do next. We created a work-around by adding a Rich Text field that will complete the save action and redirect the user as intended, but we are unable to completely remove the native save button which lingers. Does anyone know of a fix in the works for this, or even a way to completely hide the native save button from the form?Solved1like2CommentsHow to create a pipeline to count records in a table
I want a pipeline to do the following: Go to a table in an application A Search for records meeting a certain criteria in that table (specifically, the number of records that were completed in the previous month) Count the number of records found Go to application B Create a record in a table in application B Put the count of the records found in application A in a field on the form (fields: 1 application A name, 2 is count of records found, 3 date the pipeline ran) I want the pipeline to run this monthly on a scheduled date. Can someone kindly tell me the steps I would need to include in the pipeline to make this work? High-level is all I'm looking for. Thank you!Solved1like5Comments
Pipeline after import (heavy traffic/transient error)
I am trying to improve pipeline performance and need guidance on the best approach please. When approx 1000 records are created from csv import using ImportExport action in TABLE A, the pipeline should look for TABLE B ID based on a text field in TABLE A and relate. Attached sample pipeline. When records are imported, the pipeline runs, but noticed the traffic warning. Bulk upsert may not work as each pipeline trigger is on single record update.Solved0likes4Comments
Dropdown Choice Update force reselection
Hi all, I have a drop down field with choices for a 'job status'. I've recently refined the list of choices, and I want to know if there's a way to force a user to have to select one of these new choices next time they update the job record. Currently, they can leave the existing status in place and save the record anyway, with the choice highlighting in red in the report. Is there a way to do this? Thanks in advance.Solved1like2CommentsRedirect after API_EditRecord
Greetings, everyone! I'm at my wits end trying to get a redirect to properly fire in a Formula URL button. I'm using the URL as a "Submit" button that changes the phase of the record, then I want the app to redirect to a report. All I can get is a redirect to the app homepage which is not intuitive and undersirable. Here is the URL Formula: var text submitURL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_34=Items&apptoken=<token hidden>"; var text redirectURL = URLRoot() & "db/" & Dbid() & "/a=q&qid=7"; $submitURL & "&rdr=" & URLEncode($redirectURL) Can someone help me figure out what's wrong with this implentation? Thank you!Solved0likes4Comments
Section Headers on New Forms
Hello, It seems like there isn't any way to add a "Section Heading" element on QuickBase's new forms. On the legacy forms, I can add a section heading element as way to divide fields with a blue line (see the "Legacy Form" screenshot I've attached). On the new forms, I can't find any way to add a section heading. See the "New Form" and "New Form (Editor)" images I've attahced for reference on how the new forms I created look. Are section headings not available on QuickBase new forms? Please let me know. Thanks in advance!Solved1like7CommentsMuliple Choice field set with Form URL?
I am wanting to place an image on a form. I have many forms and each version may have a different image. I was wondering if it is possible to set a Multiple Choice field to a specific value using the URL the user clicks on to open the form? My thought is that if I can set the field to the correct value then I can determine which image to show on the form based on the field value that has been set. Is there a better way to accomplish this? Thanks, BrianSolved1like3Comments
