Using Dynamic form rules with override role settings by report

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I'm trying to make fields on a table report read-only based on certain conditions using dynamic form rules. Unfortunately these don't seem to translate to the table report when I use the form to override the user settings.

Are dynamic form rules supposed to work in table reports, and if not, can anyone suggest an alternative method to achieve this? Thanks very much
Photo of Rory

Rory

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Dynamic Form Rules are called Dynamic Form Rules because they only work on Forms.
There is no dynamic aspect to controlling Grid Edit behavior.

If it possible to control which fields are used for Grid Edit by making a Form which has as its only purpose a list of the fields to be used in grid edit.  Then once you have multiple forms, there will be a Forms Usage section in the forms menu which allows you to specify which form get used for grid edit by role and by report.  If you never wanted to allow a field to be editing in grid edit you can simply not show it on the grid edit form, or else have a mirror field which is a formula field equal to the field that you don't want edited, and use that in the grid edit form.  But all rows of the rest will behave the same.
Photo of Rory

Rory

  • 0 Points
Hi Mark,

Thanks very much for your response.

I have used my form to make certain fields read-only for different reports. What I wanted to do here was to make fields in certain rows read-only. From what you've said this doesn't seem to be possible. I don't understand why Quickbase doesn't allow field access by roles to be customisable, instead of just a straight view/modify.
You can make a whole row to be non editable using Roles permissions and a formula field which determines "editability".  But at present you cannot control that at the field level by row.