Create .xlsx to google drive, and open browser google sheets

[Freelance]

@ Can anyone tell me if App Sheet can...

1. Create a .xlsx file, this I have already done and can concatenate to field settings and the company name of the client.

2. open an external copy of created .xlsx, by [filepath] - Type File. - I can only get this by downloading a copy of the file created. This is where I am stuck, I need it to be able to open the created .xlsx file in Google Sheets, from the Google Drive location, but whenever I try to hyperlink the [filepath] I get errors.

Constant no file found, and a list of div open and closed statements.  I have tried naming the root path, tried not naming the root path.

Ideally I require it to 

1. Create a company folder, name of the company in appsheet_name/Files/:- this is what it does at the moment.

2. Name the activity as a folder, which I have the AppSheet creating for me.

3. Create an excel .xlsx file ready for the client/ user to input there data. this works as well, (yyyymmdd-name-ID.xlsx)

4 have an activity that can be selected to open the file.  This is where I can only get it to download, which to be honest is useless to me as I require the client/user to upload his information/ data/ text/ anything Excel/Google can take as a file and save it back in its place.  The only way I can see it ever doing this is if it loads the workbook via Google Sheets.  I can create and manually copy the URL into [filepath] this loads in the browser, but I want the app to be doing this, not me.  I have read about gettableFileURL but that does not work for sheets, has anyone ever thought of creating a getSheetFileURL??  

In short, does anyone know if AppSheet can do this?

Hopfully SW

[Peterson_90]

Yes Appsheet can do all of that.

[Freelance]

I have made it do that, but when activity is triggered it downloads .xlsx file instead of opening up in broswer.  Any ideas on making it open it in google sheets?

[Peterson_90]

Mmm, so you want to store this sheet in your google drive, and find a way that you open it in google sheets inside Appsheet, right? So that your users can update this only file instead of downloading it and work with different files, am I right? Is this what you want?