Hi โฆ First of all, thank you for such a great programming effort and lovley visulisations in appsheet.
My issue is that the app worked correctly updating or deleting data in the app to the spreadsheet, until I opened the spreadsheet in my google drive and I just expanded and contracted some columns, then it didnโt capture any data changes in the spreadsheet, even after I regenerated all the columns in the app to
Why? โฆ and what is the solution for it?
I had to contract and expand some columns because they didnโ appear in the app (taple forme) โฆ 3 columns apeared and the 3rd one took along space (even I chose Narrow field from the options in the app) Also โฆ why? and what is the solution?
That is how one problem led to another So Please help me with it โฆ to get my app look great and the more important, to find my data in my spreadsheet, to copy it later and edit when I need that in a different styles, with out any data loss.
Thank you in advanced
If you open the editor, do you see the same column structure than in your spreadsheet? Is the amount of columns the same?
Yes โฆ itโs the same structure and the amount of columns
For the 1st problemโฆ would you please describe step by step how you received this issue, thanks.
After I uploaded the spreadsheet (contains 5 sheets) to the google drive โฆ and make the app with appsheet, andAfter I finished formating my tables and UXโฆ etc I started adding data to the appโฆ and when I opened the spreadsheet from google drive โฆ it was all there (data inputs & formulas). But โฆ when I just changed the columns width and exit google drive after saving the spreadsheet โฆ I made some changes and adds from the app โฆ and then went back to spreadsheet โฆ the new entries werenโt there โฆ just the old ones Thatโs it โฆ and to be sure I tried another spreadsheet and a different app that was working โฆ so I opened the spreadsheet from google drive and repeated what I did (JUST CHANGING THE COLUMNS WIDTH โฆ NOT ANYTHING ELSE) and the same problem occured.
Guess what โฆ when I opened the spreadsheet with google sheets โฆ it showed me every thing i changed or added โฆ
The problem is with excel file viewing from google drive โฆ maybe !!!
Okayโฆ when you used the xls from the Drive, did you see all data in your app? You just didnโt see the data in the spreadsheet?
Thatโs right โฆ i didnโt see the data, and still they arenโt there โฆ but when i opened it with google sheet it showed up every thing So โฆ they are actually there but the normally previewer in google drive doesnโt doing well โฆ for that i tried in the top page option (open with google sheet) โฆ then every thing came up (inputs data & calculated data)
There is something mysterious with it!!!
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |