Hello AppSheet community!
I'm facing an issue with a virtual column of type "file" that should open a generated PDF. The formula I'm using is as follows:
CONCATENATE("/appsheet/data/Multisegraf-115134871/Cotizaciones/", [id_cotizacion_datos], ".pdf")
The default path in "Default app folder" is "/appsheet/data/Multisegraf-115134871" (see image 1). The bot has the following parameters for the generated PDF (see image 2). However, every time I use the action, I get an error indicating that the file cannot be found (see image 3), even though I can view it in my Drive (see image 4).
I've also attempted to create a column within Sheets using the same formula, and I encountered a similar issue (see image 5). When I test the formula for the virtual column, I get the following result (see image 6).
Any suggestions on what I can do to make this action lead me to the PDF correctly? I appreciate any help you can provide!
image 1
image 2
image 3
image 4
image 5
image 6
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |