I have a doc with a form where I ask the users to upload some files, but sometimes they will upload not supported ones and it’s not very obvious for them (see screenshot).
I would like to create a formula to identify if there is a not supported file in the column, and display a much more visible warning.
Does anybody know how to do that?
If I create another column where I convert to text the ‘files’ field it only contains the file names, without any information regarding if it was uploaded correctly or not.
When you load a file into a coda file type column, it gets uploaded to Coda’s servers at a url that starts with codahosted
Those PRIVATE files you have do not seem to get uploaded to Codas servers whatsoever. We can confirm that because when we look at their underlying information (the column 3 in the photo below) you can notice that it does NOT have a codahosted url
Therefore, my assumption is we can rely on whether or not a Coda hosted URL exists as the signifier of whether or not a file is supported
So your initial question was:
I would like to create a formula to identify if there is a not supported file in the column, and display a much more visible warning.
The the combination of my two formulas below should act as a solve for you! I’ve never had to implement this workflow myself, so there may be other ways. But this is the first that came to mind!
Thanks @Scott_Collier-Weir !! That’s very helpful. I didn’t know what _merge() did. Is there any way to access some of the other meta-data like the size of the file?
