Hello,
how to set an attachment as required on a workflow form?
Hello,
how to set an attachment as required on a workflow form?
Dear Torf,
you can add validate form action on specific path and include SQL Command to check if for particular WFD_ID there is attachment.
Attachments are stored in DB when they are uploaded, so no additional save action is required.
You can query [WFDataAttachmets] table if attachment exists.
Hope this help :)
Best!
You can use the builtin functions "Attachments Count" or "Attachment Exists" on either a validation rule or as an additional path validation.
If you make a validation by SQL query, you must be sure that you wrote, a condition in Where section which will check that attachments is active. All of attachments (which you have added or deleted already to/from forms) belongs to the correct WFD_ID. If you don't have any attachments on form because somebody deleted there early, validation will check it also. Check column in DB ATT_IsActive.