Invalid entry error when entering a negative number
I have a numeric-currency field that I am using to adjust a total field. If I edit the record to enter a negative number I get an error Invalid entry. But I can enter a positive number, save and reopen the record, edit the field to add a "-" then it works. So why won't it accept the "-" on the first attempt? Why must I enter the positive value, re-edit, add the "-" in order to make it work?Solved16Views0likes1CommentDefault column widths on embedded reports obscuring data
We're building a new app with the "new" form builder for the first time, and seeing an issue with embedded reports. The default column width on the embedded table reports is partially obscuring the data, and although you can manually expand each column, there doesn't seem to be a way to make those column widths stick. Am I missing something, or is this a deficiency of the new form UI? We have half a dozen apps using the legacy UI with dozens and dozens of embedded tables, and this has never been a problem. Fwiw, I found the following post describing the same problem on dashboard pages, but this is not a dashboard page. It's happening on the 'main form' within our tables... https://community.quickbase.com/discussions/quickbase-discussions/can-you-set-column-widths-for-reports-in-the-new-dashboard-pages/19595 Thanks in advance for any insight.Solved356Views1like7CommentsImporting excel into multi select text field which is connected to another table inside same app
I am trying to import data by adding existing data which is in another table but I am seeing a weird behaviour that rather than selecting the option which is already present it tries to create new option and as the option is more inside the main table it is throwing me error. Please give a reply ASAP21Views0likes1CommentHide Save Button on New Forms
Do you want to remove the native Save/Cancel buttons on new forms or new mobile forms? Add &ifv=1&hs=1 to the form URL. They must be used together for it to work and this work in Edit mode. Note: It must be ifv=1 — other values like ifv=10 won’t work with hs=1.Solved837Views1like2CommentsChange data used to populate dropdowns, based on other factors
I am brand new to QuickBase, and have been asked to maintain an existing system where users rate various information presented on multiple tabs in a Form. The data presented in stored in records in a Table, and the selection made in the dropdown on the first tab determines which record in the table is imported to display on the Form. The only exception is the data that populates the various dropdowns, which in past was imported from a single Lookup list (think numbers - 0, 1, 2, 3). Each dropdown reflected the same scoring list (0,1,2,3). Now, we want to be able to populate each dropdown on each tab with a different rating scale (0-3, 0-5, etc.) based upon (1) the selection made in the dropdown on the first tab; (2) the tab number; and (3) which dropdown on the tab (each dropdown on a single tab could have a different rating scale). I have been researching, and I want to experiment during off hours, but if anyone has suggestions on how they may have accomplished something like this, I would be grateful for your input. Thanks!23Views0likes1CommentAdd 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 list60Views0likes6CommentsImprove 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?26Views0likes1CommentChanging 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!18Views0likes0Comments