Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How can I use a field in a form rule without displaying it on the form?

Have you ever tried to build a form rule that needed some internal value that your users don’t need to see? If you set up another form rule which lists which fields should always be hidden, you can then build other rules with those fields without having to display them on the form itself:

  1. Open the table, then edit a record in the table to look at your form.
  2. Click Customize this form.
  3. Add the fields you want to hide at the bottom of the list, if you haven’t done so already.
  4. Open the Dynamic Form Rules tab.
  5. Click Add New Rule.
  6. Under the WHEN section, choose “Multiple conditions”.
  7. Change the next line to read “When any of the following conditions are true”.
  8. Change the line below to read “The user is in the role Administrator”.
  9. Change the last line in the WHEN section to read “The user is not in the role Administrator”.
  10.  In the ACTION section, change the line to read “Hide name of field to hide”. If you want to hide multiple fields, click Add Action for each additional field.

For more on form rules, please see our Create Dynamic Form Rules help topic.

Comments

How to create a rule to check uniqueness of a filed

Hi I have a formula field that I want to use for uniqueness. In the filed level I am not able to make it as unique field becuase of the formula. But I heared that I can do this with rule

Hi Vijayan, For performance

Hi Vijayan,

 

For performance reasons, formulas in QuickBase are typically not able to be marked unqiue unless they contain the Record ID#. For more information, it would be best for you to open a support case by going to Help > Manage Support Cases > + New Support Case so one of our customer care specialists can help out with your specific formula.

 

Thanks,

Brian

Another Route

This is the simple method for one field, but you may want to add additional fields as well and maybe make it a little easier than having to add a field to the Rules, simply create a new section, I always call mine admin, apply the rule to that section, now when you add something to your database you can just add it to that section to hide it.

RE: Another Route

Hi Nate,

I have done it that way before, but the reason I no longer use sections for this is because new fields are added to the bottom of the form. That means that the new fields are hidden by default, which can get confusing. 

As mentioned above, you can click ADD ACTION to use the one form rule to hide several individual fields.

 

Thanks!

Brian

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit