Change 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!
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 list
Improve 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?
Changing 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!
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>" )Relationship Condition Dropdown stopped to work after formula update
Team, I have a challenge to my relationship update. For my relationship I was using "Formula Field" [SMO_Predecessor_Key] which was selected to create conditional dropdown based on its value. [SMO_Predecessor_Key] used in formula another field [SMO CPS Template] which had some logic in it based on field [SMO]. I no longer need this logic so I decided to rewire [SMO_Predecessor_Key] directly to field [SMO]. After I did it I have problem that my Relationship PROXY field does not work in Legacy Form. It ask to choose [SMO_Predecessor_Key] even if this is already selected. I notice that if I re-select value in field [SMO] in form (i.e. remove value, select it again, even without saving, this starts to work. So problem is with data which are already filled in. [QUESTION] - is there a way to force such refresh to all records and to not need to do it 1 by 1 in form? What I tried: I tried to Import records ID# and field SMO but during Import No update to records (as SMO does not change). Tried to create new field [SMO_Predecessor_Keyv2] and update Conditional Value to it and back. But not working as well. This is how dependency of fields looks line (Blue changed to Green) Current workaround but not well seen by users 😢Limiting the Ability to add Child Records Based on Drop Down Field Value
I have a two table application and was wondering if there is a way to limit the amount of Child Records that can be added based on the selection of a Drop Down field? When a user opens the form the first thing they are asked is the level of a dealer. Once that vaue is selected is it possible to have a rule that says if dealer level field is say "Gold" "X" amount of child records can be added. Once that limit is met a message is diplayed telling the user the max amount of records has been met or the "Add Another Record" button goes inactive.
