Formulas based on absence/presence of attachment

[Parker_Smale]

Hey all!

Hoping to have a toggle automatically switch to “on” if/when an attachment is added to an attachment column in the same table. I understand how to use trigger functions, but am not sure on how to incorporate the attachment column into that at all. Is there a true/false or equivalent connected to attachment columns?

Any guidance (including telling me this may not be possible atm) would be appreciated!

Cheers,
Parker

[anais-grist]

Hi Parker. Welcome to the forum!

You can use the bool() function in a formula column to return whether or not an attachment column has a value (i.e. an attachment).

bool($AttachmentColumn)

Hope this helps!

[Parker_Smale]

I knew there must be some sort of easy solution here! Thanks so much