Monitor file storage

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • peterberlin
    Active Community Member
    • Mar 2015
    • 1004

    Monitor file storage

    Hello
    I would like to monitor a field of type file with formula.
    How can I determine whether a file has been stored or not.
    filingfieldname == null
    filingfieldID == null
    does not work
    peter​
  • lazovic
    Super Moderator
    • Jan 2022
    • 809

    #2
    Hi peterberlin,

    You can use the following formula script to check if a file has been uploaded to a field, and output a certain answer in the record description (or do something else, depending on your wishes):
    Code:
    ifThenElse(
        fillingfieldId != null,
        description = 'File is uploaded',
        description = 'File is not uploaded'
    );

    Comment

    • peterberlin
      Active Community Member
      • Mar 2015
      • 1004

      #3
      Many thanks for the quick reply.
      But I have to check if no file has been stored.
      That's why I tried
      fillfieldId == null
      to use. But it doesn't seem to work​.

      Comment

      • lazovic
        Super Moderator
        • Jan 2022
        • 809

        #4
        peterberlin,

        You're welcome.

        So, you can simply use the following formula script:
        Code:
        ifThenElse(
           filingfieldId == null,
           description = 'File is not uploaded',
           description = 'File is uploaded'
        );

        It works correctly, I have checked both the previous variant and this one.
        If it doesn't work for you, then there might be a problem with the general syntax of your formula script.​ You can show it so we can go over the issue together.

        Comment

        Working...