0

is there a formula to disconnect the link field to a table ?

i would like to disconnect the field linked to the table with a formula. I am trying to disconnect the field when i update another link field.

I hope i've been clear. thanks in advance for your help. 

4 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    You can use:

    referencefieldname := null

    that will clear out the selection.

      • vacunasrls
      • 1 yr ago
      • Reported - view

      Fred Hi thank for helping. It seems that doesn't work. it shows an error like : "it must return a number or an ID" 

      • Fred
      • 1 yr ago
      • Reported - view

      Sorry, haven't done this in awhile. I doubled check and you can use 0.

    • Alan_Cooke.1
    • 1 yr ago
    • Reported - view

    I use a button with 'fieldname' := 0.  The button label I use 🔗 which can be found under WIN+; search for link.  If you are on a MAC I'm not sure how to get 'link'

Content aside

  • 1 yr agoLast active
  • 4Replies
  • 74Views
  • 3 Following