Why does my form rule not work when in view mode?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a multiple choice field called [Billing Method]. The form rule says to show the URL formula button called [Add Project Team] when [Billing Method] is equal to "Hourly" or "Fixed Fee", but to hide the button when the billing method is equal to "Sub-project Hourly" or "Sub-project Fixed Fee". The button does properly hide in Edit and Add mode, but unfortunately the button is always visible in View mode no matter if the condition is met or not. And this is just terrible since I need to prevent users from pressing that button if the condition is met. There are two forms in this table, but the other form is only used to view other unrelated fields, nor does it have any form rules. Also the form properties on the main form for all the relevant fields are set to display in all three modes, which of course it has to be in case the condition is not met. This has to be a glitch right? I can't figure this out.
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 3,772 Points 3k badge 2x thumb
I would program the button to react to the field; rather than a form rule.  If a button is on a report, it's not going to look at the Form to determine whether or not it should hide.

Your [Add Project Team] button formula would look something like this:

If([Billing Method]="Hourly" or [Billing Method]="Fixed Fee",

(existing button formula)

,"")

This way, the button will properly display either in a Form OR in a Report.
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb
Good idea.  I will do that.  But regardless, do you know why the form rule does not work when viewing the form in view mode?
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 3,772 Points 3k badge 2x thumb
Is the field you use to control your button controlled by another form rule; or possibly set as "read only" on the Form Layout - sometimes that can affect whether a rule can "read" it.  Often we have to put fields on a form in a hidden section (hidden using a form rule) so that it exists on the Form (the form can see it) and it can be used to control Form behavior; even if the Users should not be able to see it.