I had asked this over in G+ and got a good answer. So Iโll go for a deeper dive here. First let me say that I have taken over a set of appsheets from our former CIO and Iโm getting better at this but I still feel new some times.
Under Columns i one called โTicketsโ that is all set up in SQL. Within here I want the ability to do file downloads. So I followed the directions and created the column called โFileโ, added the line, and I got that to work but with an issue. The problem is that this wonโt work in SQL. This is fine because I have another column called โFile Downloadโ made with Smartsheet with a column in it just like above.
Iโm probably using the wrong terminology above. I want to call them tables but Iโm using the wording on the appsheet page. So how do I reference my โFile Downloadโ made in Smartsheet in the tickets one? What is the syntax that I need?
So, do you mean in the table that is attached to a SQL data source your File
column type does not work? Could you clarify what you exactly mean? What happens?
Yes it doesnโt work. When you click on the download button, that points to the SQL database, it changes the name of the file into something that cant be opened. Let me go through the steps.
So you use my app to enter a ticket.
You get down to the file download button and add a file.
In this case Iโll do โCreating an IT Ticket.pptxโ
Which shows in the file box
Now I click on โSend Requestโ
In the app the file shows as zICKwjNR.File.043821.pptx
When you click on it this is what you get.
The URL is: /template/gettablefileurl?appName=IMSITRequests-131506&TableName=Tickets&appVersion=1.000734&fileNam...
Error retrieving file โzICKwjNR.File.043821.pptxโ: File not found : Failed: Path: โ/appsheet/data/IMSITRequests-131506/empty.txt:zICKwjNR.File.043821.pptxโ, Message: โโ.
Please contact support@appsheet.com
Can you actually find an uploaded file named: zICKwjNR.File.043821.pptx anywhere in your Google Drive or whatever cloud provider you are using? Is something with that name located in /appsheet/data/IMSITRequests-131506/ path?
There are three Google Drives attached to the apps. I have the logins for two. Like I said, I inherited these apps. So what I was trying to do was match the account sources to the logins I have. Which is easier said than done. My โGoogle-3โ is the one I created. So I know which login goes with this. The file isnโt in there.
Next I have another login and the file isnโt in there either but I canโt tell if this is my source โGoogle-2โ or โGoogleDriveSCFFโ and I donโt see a way under account sources to find out what the google login is that goes with each data source.
So I donโt know if that file is hiding in the third and last data source.
I believe for that SQL table AppSheet will upload the file to the primary storage which belongs to the app creatorโs account, so I am not sure how you would want to check and troubleshoot this without having access to that Google Drive, if that is the case and the account owner has left organization.
But if it is necessary to have SQL table in the same app that is owned by him, perhaps you could take advantage of the relatively new feature that allows to consider SQL database for file storage too. This way you bypass primary storage for the SQL table. You can read about it in the document below:
I am also adding @Harry, in case he wants to add any comments, or correct me if I am wrong.
I thought I was going to have to recreate this in Smartsheet since this app isnโt in production yet. I was trying to avoid that since I havenโt created one from scratch yet but it doesnโt look too difficult. Iโll look into the SQL file saving link.
If it is not in production yet, I would recommend just build a new app that is fully owned by your account, or transfer the app to your account and then switch the data sources owned by former CIO to new ones owned by you; just the peace of mind that your account fully owns everything on the app is worth the extra work.
There are several important apps on the account that are in production. Meaning that changing them over is risky. Itโs something that I plan on doing in the long term but in the short term I am propping them up and keeping them going. Itโs in my plans though.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |