I have an upload field in a table. Is there a way to require that all filenames be unique?
Thanks in advance!
Why do you want them to be unique in Forms?
Thanks for your response!
There should be exactly one receipt per transaction number and this would validate that.
Can't you change the setting on the upload field to only allow 1 file? I feel like I'm missing something.
Each upload field allows only one file. However, there are multiple rows in the table and I want to ensure that the end users don't drag the same file into more than one row.
It also causes problems with the workflow that processes the stored files. If the filename changes when stored (ex. adding "(2)"), the custom query against Forms can't find the associated row data for indexing.
Thanks!
Ah, so you want the receipt to be unique when compared to the other upload receipts. I have not tested this, but using JavaScript in the Modern Designer, there is getFieldValues. I would be curious to see what it returns for an upload field when a file is uploaded.
I'll give it a try. I'm new to javascript in the new designer, but can probably figure it out. Thanks!