Is the a function that identifies if a row has an attachment

Frank Falco

I want to set a flag (symbol or check box) on a row if that row does not have an attachment.

I know I can filter on that, but that is not the whole solution I need.

I really need to have something I can count and filter on in reports

Andrée Starå

@Frank Falco

Glad to hear you're well!

You could have a Workflow that triggers when an attachment gets added, and then that flags or checks a box, but the issue is that (as far as I know) there isn't a way to do the same when deleting an attachment.

I'd recommend adding another checkbox or flag that the user would check if they remove all attachments. Then, you'd have a workflow that triggers to remove the first checkbox indicating any attachments on the row.

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Frank Falco

I hope you're well and safe!

Would you need it to work if you also remove all attachments on a row?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Frank Falco

@Andrée Starå I am doing well, thanks for asking.

Ideally, yes. There should be an attachment so if they are removed need to know that.

I need to know if it has or does not have an attachment. Then I can checkbox set in either case.

Andrée Starå

@Frank Falco

Glad to hear you're well!

You could have a Workflow that triggers when an attachment gets added, and then that flags or checks a box, but the issue is that (as far as I know) there isn't a way to do the same when deleting an attachment.

I'd recommend adding another checkbox or flag that the user would check if they remove all attachments. Then, you'd have a workflow that triggers to remove the first checkbox indicating any attachments on the row.

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Frank Falco

I was afraid of that.

Unfortunately, the users cannot be trusted to consistent set flags.

It would be great to have a hasattachment function.

Will have to suggest that with a lot of the other functions we have been asking for.

Thanks for your help @Andrée Starå

Andrée Starå

@Frank Falco

You're more than welcome!

Yes, great idea!