cannot create appsheet app from google sheets

[Cubinche]

I have created some Google Sheets from which I want to create an AppSheet app. I have the AppSheet Extension installed in my Google Sheets Browser, but the 'Extensions>AppSheet>Create an App' menu option is grayed out.

I've never had this problem before and have used this feature for several years now and as recently as about two months ago without any trouble.

I checked Google Security for my Google Account and it did show the AppSheet access I allowed as being "risky", so I clicked through the options, confirmed the allowed permissions and indicated that the AppSheet access I allowed is 'trusted'.

I then went back to the browser, cleared cache and reloaded the Google Sheets page but am stilll having the same problem. See screenshot below:

Please help and thanks in advance.

[WillowMobileSys · Accepted solution]

AppSheet is recognizing that your sheet is not properly structured for an app.  The first column cannot be blank. 

Note: your data rows in the app must have some kind of Key value.  I strongly recommend using a dataless key - which is simply a column designated as the Key value and used for nothing else.  AppSheet has a UNIQUEID() function to help with assigning this value.

So, I suggest adding "Asset ID" as the header in column A.  Then you will be able to generate the app AND AppSheet should automatically setup the "Asset ID" column as the Key column with the UNIQUEID() function already inserted into the column and ready to go.

IMPORTANT:  For your already existing rows of data you will need to manually assign them a key value to be seen in the app.  I would just insert the values 1,2,3,4,...  for now. 

And I guess I should mention, do not try to use sequentially numbered key values - they won't work anyway when there are multiple people using the app.

[F1]

Sorry apart dear @WillowMobileSys ! I am new to even scripting, but infect this solution did't helped me, than i simply copied the data from an old spread sheet that was once being used to create an app to a new one as "Values Only" and gave a new name to it, it really worked! but still i am interested to know the actual solution/ option/ facility that Google has provided for users like me! Thanks.

[Cubinche]

Thanks for your speedy and accurate response, which solved my problem. You nailed it within your first sentence:

"AppSheet is recognizing that your sheet is not properly structured for an app. The first column cannot be blank."

A bit of clarification regarding the remainder of your suggestions for others who might benefit from this thread:

1. I was a victim of my own experience with AppSheet, which includes the use of 'Show | Page_Header' type columns that I use to aid in the layout of forms. AppSheet defaults to "Column Type" = "Show" when generating the structure of columns that are blank and interspersed among other columns. I mention this because it was only necessary to delete the first blank column as you suggested and not the three other blank columns contained among the other columns within the sheet.
   
   
2. I already had a n AssetID column that will use the AppSheet function UNIQUE(ID), for which I used Google Sheets formula << =DEC2HEX(RANDBETWEEN(0, 4294967295), 😎 >>. That formula mirrors AppSheet's UNIQUE(ID) function. Once I entered my initial data within the sheet, I selected all data that was a product of that formula and pasted the resulting values in their place. The point here is that this particular column is near the end of the spreadsheet, behind an eventual 'Admin' 'Show | Page_Header" type column - that is, a column that is blank interspersed among other columns. The AppSheet 'Extensions>AppSheet>Create an App' menu option worked flawlessly even with this column near the end and after other blank columns before it.

Thanks again for your excellent, speedy, concise and accurate solution. I'll mark it as definitive.

Cheers!