Forum Widgets
Recent Discussions
Error - Over 100 Multi-select values
To overcome 100 value limitation, I created "Agent" table to capture all drop-down values and used it as reference in Company's Employee field as below. It has approximately 600 values. But when I save the record, I encountered 100 limit error (The field with ID '45' would have more than 100 choices:) I tried switching the Employee's field Input type to From list, cleared values and back to From another field. But it didnt work. Is there an alternate solution for this? Please guide.
How 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!New 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?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.
Form Error: More than 20 Multi select
I created a multi-select text field which should use values from another table's text field. On the record page, when I select value and save, it displays below error message. I removed values but still the same - switched input type "From list" (cleared values) back to "From another field". Please help. The field with ID '45' would have more than 100 choices:
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.Freelance/Job Quickbase Developer and Admin Full stack developer
Hi All, I Have 6 yrs of experience in quickbase development, Optimization, Automations and integrations I have integrated different applications like asana, salesforce, GCP and procore with quickbase. I have implemented few integrations to fetch the data from Google forms/Google sheets and to update the data in Quickbase table with quickbase APIs. mailto:vkamala.upw@gmail.com Regards, Kamal.
PDF Attchment View
I am trying to view a thumbnail of a PDF in a report or from file attachment. I have used the image preview in the Quicbase excahnge and have modified it to my corerct fields but I am unable to see the thumbnails. Any hlep is appreciated. https://ciclops.quickbase.com/nav/main/action/exchange/qb/library/image-preview My Formula - Rich Text field If( [Tear Sheet]<> "" , "<span style='width:400px; display:inline-block;'> <img style='max-height:400px; max-width:400px' src='" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID# - Company] & "/e75/v0' /></span>" )
Changing owner of notifications - role limits?
Hello! What drives the drop-down menu in the "change owner" email list in notifications and subscriptions? My list comprises of me (only person with app edit permissions), and my system office's realm manager (I think that's what their role is anyway). I need a middle-ground to change subscription ownership to my team members - including those who otherwise have full app access, just not app edit permissions - as well as a new role coming on board that will have more limited access, but will be crafting their own notifications. Thanks!
