I have a couple of instances where I want to create a files which are both stored on the drive and emailed to a user.
To be able to attach multiple files to an email and/or to be able to create a record in a table with a file column referring to the file, I need to switch off the time stamp in the file name.
I am not sure if it is a big problem but the file names then become very easy to guess. If a user gets a file called something lime “johm_report_25_may_2021.pdf” it is not very hard to guess the files names for other reports.
Ideally, I would like to include a simple hash in the file’s name. That would make the system more secure as it would be impossible to guess the names (depending on the algorithm) but it would allow me to find the files again as long as i have the input for the hash.
I don’t think there is a HASH() function in appsheet.
Has anyone done this and do you have a not too long formula for a hash that works?