My AppSheet references a google sheet for its source path. I have columns set up to name different types of equipment. Each column is โEnumโ type and I have different serial numbers listed for each item. My problem is when I add a column (i.e. a new piece of equipment) to my google sheet and regenerate the column on appsheet I loose all my previous Enum serial numbers entered, and the โtypeโ changes to โtextโ. Have you any idea why this might be happening? Is there a way of adding a column to google sheets without messing with any of the previous columns? Any help greatly appreciated.
Hi @Jason_Flynn, does this consistently happen? Iโve tried to reproduce the issue on my side and it retains the EnumValues setting across regenerates.
Generally speaking, AppSheet tries to keep as much information as possible across regenerates. (See this related thread: https://plus.google.com/114245848290409200820/posts/jcxdA1sBRyQ) Hello Experts, Im wondering if there is some way to keep the config on columโฆ plus.google.com
Hi tony, thanks for the response. I looked into that and I just discovered that if i regenerate the table without making any change to the google sheet the same problem occurs. This means that the problem is already within the sheet before I make any changes to the columns. When the data is recorded by an employee from the app the information is recorded in the google sheet. So now there is lists of information below each column heading. This is probably the first time Iโve regenerated the column since making the app. Would this be the cause of the problem? If so can you a suggest a solution?
@Jason_Flynn Can I take a look at your app and the underlying spreadsheet? Iโll just need the app name and youโll need to share the sheet with tony@1track.com. Let me know the name of the enum column that is causing the problem.
App name is โFlow Technology Inspectionsโ I have shared the sheet with you now also. Problem column is โEquipment Inspection Appโ.
I am trying to add a new piece of equipment in addition to โBeam Trolley (GA2) (SF 09B)โ โChain Block (GA2) (SF 09B)โ etc. without affecting the existing columns.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |