Dynamic form rule inconsistency- (display message on open)
Hi -- I'm trying to create what I thought would be a simple rule to display a message when a record is opened, if a field is set to a certain value. I can't get the rule to work, but as I have been troubleshooting, I have found certain field types work and others don't. So far, I see that checkbox fields seem to work, but formula-based checkboxes and multiple choice text fields don't. Can someone explain why this is, and if there is a work-around? I would like my message to be based on the a formula-based checkbox being checked.
Duplicated record fills blank user fields with "[object Object]"
When duplicating a record from a new-style form, all blank user fields seem to be automatically filled with "[object Object]" upon save. The user fields are flagged to copy the value when "Copy this Record" is used. Happens in Chrome and Edge. Tested this in a new table with no pipelines or QB actions. Has anyone seen this and know of a fix?
Removing Blank Input Type
Hi, I am new to Quickbase, I have a table with multiple columns in it and there is a location column that I am using. In the Location column I want to show only 3 values. When I try to add the 3 items, the system auto creates a blank option too. I don't want that option, I am trying to turn that off. Any ideas on how to do that? The field properties are Text - Multiple Choice.
Pop up window from table home to preview record
Wondering if there is a way to create a button or link on each record so that when viewing from a table home report would open a smaller pop up window that would display some of the records details? Would also like to then have that window pop up have a button which could be clicked to view the full record. Would be nice to not have to display so many columns on a table home report, instead the preview pop up could hold 3-5 data fields with the option to open the full record.
Limiting selection choices on a multi-choice field based on what has already been selected
I am trying to create a rule on a form that will compare the entries for multi-choice fields and if a choice is already selected, then it is not available for the current field selection. This way, a choice is not selected twice. These are 5 ranking fields ( 1 - 5) - all with the same picklist. For ranking field 2, I want the rule to compare fields 1,3,4 and 5 and only display the picklist for 2 with the remaining available options. Greatly appreciate any and all help and suggestions for doing this. Thanks, Monica
