I know that something similar to this has been posted before. But I have been almost one month already + Appsheet Team has not answered yet, so I would love to ask for your kind help as I am already quite frustrated, I cannot get it .
We have 2 prototype apps:
1x for our clients, called โAutoQuoteโ
1x for our suppliers, called โSupplierโ
After the Client books at โAutoQuoteโ, the Supplier will see it at โSupplierโ and confirm it >> automatically is generated an invoice (by a bot) for the Client (note: the Supplier will also upload their invoice for us).
Whenever the invoice is generated, it is registered in a Table ALL QUOTs , in a column [Invoice]. But the problem is that it generates a link referred to the app from where it was generated (i.e. /Invoices/โฆ), this means at the app โSupplierโ.
The good thing would be that the link generated would NOT be i.e./Invoices/ but https://wwwโฆ so that the other app โAutoQuoteโ can still read it and show the invoice to the Client, who is accessing from the app โAutoQuoteโ.
Please could you help?!! Thanks so much!
This just works when opening a file in google drive.
Dear Steve and Luis,
Thank you very much for your kind help. I am making a complex app and Iโm very happy with Appsheet but this is already getting me frustrated after 1 month trying so many things, and no way. Please could you give me another handโฆ?..
With the bot at the app โSUPPLIERโ the pdf is generated & saved at file /Invoices for Agts/.
The problem is I am not writing well the path, somehow.
I have 2 columns:
[Inv. AGT] with the App Formula:
and
[Inv. AGT WEB] with the App Formula:
, following the instructions that you sent me Steve (thanks), but something is happening that the name of the App & the table do not appear. Anyway I have tried, adding them manually to the link and I cannot get it eitherโฆ
I also think that the problem is mainly in the column [Inv. AGT] because when I click on the symbol of the app nothing appears:
Thanks so much again!
Btw, Appsheet team has not replied yet to me
Your use of CONTEXT() is wrong, though I know you meant well. The first use above should instead be exactly:
CONTEXT("AppName")
The second should be exactly:
CONTEXT("Table")
No need for you to substitute the appropriate values yourself.
@Jewel the reply Steve has make will help you visualize your pdf but only if your data is located in Google drive.
I currently use Sharepiont (office 365) but the url isnt โstandardizeโ like googleโs
As far as I know, the expression Steve explained will work to any backend service, it does not matter where the images and files are saved.
Correct.
Also my understanding AppSheet is no way to save files and images to Sharepoint, but it would save to OneDrive.
it do save it in OneDrive but i can see it in sharepoint, but the expression Steve has show, had only work for me when I use my google account with a sheet in Drive.
Thanks all my ANGELS of Appsheet: Steve, Luis and Tsuji Koichi.
I tried what you said, Steve, but still the system cannot find the file:
So I think the error is on how I have programmed the app to find the fileโฆ
If at the bot I inputโฆ
CONCATENATE([Booking ID]," ",[Booking Detail ID])
and on the tableโฆ
Thenโฆ where is the error?.. I have tried 1000 formulas during one month but it resists itself THANKS so much dear ANGELS!
Could you share the relative path for your current default app folder?
you can find info pane, properties tab.
Sure:
Thanks so much Tsuji!
What I mean is this.
So sorry. Sure here it is:
Sorry I had to delete the name of our company but letโs say โSupplier XXXโ Thanks so much again
Try this one out.
On your source table, create virtual column and set to file type.
For App formula, push the relative like, which looks something like this.
`
โ/appsheet/data/SupplierXXXX/Invoices for Agts/โ&Concatenate([Booking ID], โโฆ)&โ.pdf"
`
I can not see your full expression for File name prefix which come to the end of the relative pash, please amend URL accordingly to match your environment.
This will generate the file action. You can pass this column value to Automation template where you will see hyperlink to reach out the file on the output file (PDF etc)
Thanks so much for the idea!
I have tried it but unfortunately it cannot find itโฆ
But the bot creates the file and save it well:
If we recheck:
, where:
CONCATENATE([Booking ID]," ",[Booking Detail ID])
โฆ thenโฆ on the table I created a virtual column:
No idea where is the errorโฆ By the way, the file where these PDFs are being saved, I have made it viewable by anyone with the link.
Thanks so much again!
As far as I see your expression is valid.
Possibly file cache doing something wrong.
Refer to my tips and tricks I introduced here.
Change your system generated fie action using this technique.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |