0

Displaying a field that is null based on formula

I have a Serial No text field for input and once filled in is made invisble and replaced by a formula field showing the data.  Idea being that it can not be changed once entered.  Problem is I have to comment out the code that does this in order to edit it myself as owner/admin.

Not entirely desirable.  I could have a yes/no hidden somewhere to write/not write but I am wondering if there is not a neater, slicker way of doing this.

This is the code:  'SELECT MODEL NUMBER' and 'SERIALIZE?' and not 'SERIAL NUMBER'

Serial Number is the text field and this code sits in the formula field 'SERIAL'

Any ideas?

2 replies

null
    • Ninox developper
    • Jacques_TUR
    • 1 yr ago
    • Reported - view

    In this case, I use the "display filed only, if" trigger with the isAdminMode function

    isAdminMode() or ( 'SELECT MODEL NUMBER' and 'SERIALIZE?' and not 'SERIAL NUMBER')
      • Alan_Cooke
      • 1 yr ago
      • Reported - view

      Jacques TUR Thanks will explore this option - for now I have added an ADMIN TAB userEmail() my email and have a yes/no there.  That way I can use ADMIN TAB for lots of things.

Login to reply

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 92Views
  • 2 Following