Save and Continue Issue
Issue with native Save and Keep Working button. I have a form, on which are several fields that a user completes, the results of which feed into several GetFieldValues fields. These retrieves prices from another table based on the selections made. That part works fine, but then there are some additional calculations made using that price and other fields on the form, but the price isn't "retrieved" until the record is saved. Thus, the need for the Save and Keep Working option. But that button doesn't behave in an expected way. So I'm struggling to determine the cause within my environment when using the native Save and Keep Working button. First: after the first time this button is selected, the Save and New option no longer appears. And Second: sometimes when using this option, and just Save, the form saves but a new empty form is presented. Is there a better/different way I could save and continue mid-form data entry, so that my price retrievals occur, but allow the user to still have the option to save and add a new record?88Views0likes13CommentsEmbedded Report, Add Record button not showing
I have a form with multiple tabs onto which I have embedded reports from related tabled. When the relationship was created a Report Link and and Add button are created. I generally do not include the "Add button" on my form as the embedded report has a built in Add option. I also know that on a form, you can specify whether or not to show that built in option. My issue is that I have an embedded report that isn't displaying the built in add option. I have confirmed: (1) that the form is not hiding this option, (2) that the table allows for new records to be created, and (3) that I have ample permissions to access the table and create records. What other reasons would cause this issue? As a side note, the form has 7 tabs, each with an embedded report, and this one is the only one not showing the built in add option. What obvious reason am I missing?29Views0likes5CommentsInvalid 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?Solved26Views0likes1CommentDefault 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.Solved415Views1like7CommentsImporting 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 ASAP31Views0likes1CommentHide 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.Solved873Views1like2CommentsChange 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!32Views0likes1CommentAdd 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 list69Views0likes6Comments