Hi All,
I have form, the field name is [draft_spk], i want to check the file name, does the file naming contain the word ‘Draft SPK’ or not. I was try config on the column:
Data Validity:
Valid if:
IF(FIND(“Draft SPK”, [_THISROW].[draft_spk]) = true, true, false)
Invalid Value Error:
“The file must contain the words Draft SPK”
But, after I save the appsheet and then re fill form [draft_spk], i can’t get the file name, filename is empty when I attach a file into [draft_spk]. I always get an invalid error value, because the current file name is empty, even though I have filled in the form.