0

How to attract attention if there are attachments

Hi all.

If a record has attachments (in the attachment tab, not in picture fields), I'd like to make that fact known graphically.

I tried to change the color of the "Attachment" tab, without success.

Is there a way to programmatically check if there are attachments or not?  (I could then "colorize" a formula field in my table...)

Thanks!

M_ichel

6 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    You could use a formula like this to check how many attachments there are:

    cnt(files(this))

     

    also check this tread : https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/attachments-selector-or-also-photo-viewer-5ef78da6cf794465de22feb7

    for an interesting use case example.

    Steven

    • M_ichel.1
    • 3 yrs ago
    • Reported - view

    Thanks!

    M_ichel

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    Just stumpled cross this !

    Technically a very simple thing but in application brilliant!

    Instantly transforms my sales staff user expeirence and saves all that hopping back and forth across tabs just to see what might not be there!.

    Thanks Steven for helping me to help my team :-)

    • M_ichel.1
    • 3 yrs ago
    • Reported - view

    @Steven:  sorry, but could you give me a few details more on the “cnt(files(this))” code?  I“m a newbie with Ninox and couldn”t find a reference to the “this” keyword in the Ninox documentation.  Where, exactly, should I insert this code?

    Thanks!

    M_ichel

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    You have to put this code in a formula field exactly as it is : cnt(files(this))

    the keyword “this” in the code means the current record. So you will see a lot of

    let currec:= this in example lines of code.

    Hope this helps.... 

    Steven

    • M_ichel.1
    • 3 yrs ago
    • Reported - view

    Hi Steven.

    Ok.  Got it. 

    (It“s the ”files“ part that was confusing me...  I expected something along the lines of ”attachment“...)

    Thanks a lot.  Works great!

    M_ichel

Content aside

  • 3 yrs agoLast active
  • 6Replies
  • 586Views