I am uploading pdf files in my appsheet app. The files are being uploaded to a specific folder, depending on the type of the file. Each file has a specific name, based on formula. This used to work flawlessly but recently something must have changed and now i can not set my app to name uploaded files according to my wishes.
I have an app for tracing incoming invoices. I am adding pdf of the invoice manually and the files are then uploaded to a folder which i share with my accountant. I would like the files to be named in a meaningful way, i created an initial value formula for that:
concatenate([Zaporedna številka]," “,text(right((“000”&month([Datum izdaje računa])),2)),” “,[Partner],” “,text([Datum izdaje računa],“DD MMM YYYY”),” ",[Unique ID])
I also have a virtual column as a key and a formula “=Ima slike Key” (the upper column).
Until recently all my uploaded file were named according to that formula in the key column+name of the file column+time stamp, now the files are named in the format like
UniqueID-column2-column3-some random number-name of the file column.timestamp.
Any ideas what might have happened? I haven’t changed anything in the app.
I have an app to upload invoices to a folder shared with my accountant. I add files(pdf) manually.
i have a column with an initial formula to concatenate the meaningful name. I also have a virtual column with a formula which equals the above column. This virtual column is marked as a key.
Until recently all the uploaded files were named accordingly to the formula with some random number, file column name and time stamp.
Now the files are named [UniqueID)[three other columns)_[random number)[name of the file column)[time stamp)
I can remember when setting this up for the first time i also had problems but i somehow solved it with marking some column as a label, but not sure about that.