I have a records table with a column url type. I would like to have this column auto compute as url. I already created a bot and a template, “when a new record is created, make a new file” and the pdf file automatically save to appsheet data in drive. I want this pdf file link to automatically place in URL column of my table when a new record is created.
Could you please include some details of how your PDF filename is generated - an example of the path its saved to and an sample filename will also help.
One thing to check is if you have the “Disable Timestamp” checked/turned on (see below). If not, and you have accepted the default, then the filename is created with a Timestamp embedded in it. You will NOT be able to create a URL to the file in this case as you can NEVER know, in an automated fashion, what the actual value of the Timestamp was when the file was created.
Since your circled area in the image you provided is blank, AppSheet is using a default folder name. Look into your G-Drive to see what folder your files are being saved into and that is your folder path.
Insert your desired folder path into that circled area in your file creation task.
Then in your Virtual Column, as @VOLODYMYR_TYROL suggested, change the column type to File and insert into the APP FORMULA to create your folder path + filename, a CONCATENATE() function but you’ll need it with the following modifications:
CONCATENATE(“FOLDER PATH/”, [LPO Number],".pdf")
There needs to be a “/” between the folder path name and the file name. The [LPO Number] column value you used in the file creation task is the file PREFIX only. You need to add the suffix based on the file generation type you selected - which looks to be PDF.