Pinned Discussions
Forum Widgets
Recent Discussions
Add data to Multi-select field
Hi, I want to use names from a text lookup field as the source of a multi-select field. Some lines of the text lookup field have multiple names which are currently separated by ";". On the multi-select field I want to display the individual options on a separate line. Is this possible? This is an example of what I have: Brand (Text lookup field pulled from a separate table) A B; C D; G; H E; F This is what I want: Impacted brand (new multiselect field created) A B C D E F G H I want the user to be able to select multiple brands from the list0likes5CommentsError - 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.0likes4CommentsNew 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?0likes2CommentsImprove the performance of loading 10000 rows for a multi-select field
Friends, I have a multi-select text field whose source is a table. The table has nearly 10,000 rows. When the user clicks on the field to select the choices, it takes forever to load all the rows. Even the browser asks if we want to wait to close the window. Is there any way the speed can be improved? I check the field properties; there is not even an option to filter based on the value of some other field. Any ideas?0likes1CommentChanging the Record Owner: New Forms
Hey Qrew! For my help desk application, I need to be able to change the record owner from time to time in cases where I add tickets on behalf of requesters. It was relatively simple in legacy forms to change the record owner at the bottom of the page, and I'm wondering if anyone has found a way to do the same in new forms. If I need to, I can still view the record in legacy forms and make the switch, but it is slightly annoying and takes extra time to switch back and forth between form styles and view modes. Also, I attempted to create a workaround by using a pipeline to edit the record based on an override field; however, I got an error back stating that the "Record Owner" field cannot be modified. I also tried to take the long route and use the QuickBase API_EditRecord, but I ran into walls that way as well. So, at this point, I am open to any suggestions. All thoughts are appreciated!0likes0CommentsHow to create Shared Reports in the LIVE version?
I have a quickbase app that I created for my users. I use the sandbox feature for version control etc. My users are asking for complex reports to be created that they can use. But I am unable to create them in the Live version of the app. I can create personal reports but not shared reports. It used to be that you can always (in fact quickbase used to recommend) shared reports in the live version. But not anymore. How do I do this?0likes2CommentsThrowing out a Quickbase idea!!
I'm on the Qcrew meetup for cascading permissions, and it reminds me how much I detest the (necessary) zillions of tables we might create, and how they are potentially confusing for an end user. I know we can hide tables, but they're also a lot to look at as an administrator. Would Quickbase ever consider a sort of self-designed table organization structure -- wherein users can organize tables in nests that make sense for the user, like a folder structure (of course, some tables are children under multiple parents) -- or maybe even offer a dynamic structure offering? The sheer number of tables can be incredibly overwhelming as apps get more complex.1like0CommentsHow 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!Solved1like5CommentsPipeline 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.Solved0likes4CommentsForm 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:0likes0Comments