Delete columns, must remove fromGoogle sheet?

[ErgoMan]

If I delete an app column, do I need to change the google sheet? For instance, I want to use two apps off the same data sheet. One will have a sinigificantly reduced number of colums form the other. Will this work? Thanks!

[Steve]

All columns of a worksheet used by a table in AppSheet will occur as columns in the table. There is no way to avoid it.

[ErgoMan]

Hi Steve,

Thank you for the reply. I did not ask my question well. Can I use two different apps off the same data sheet? I would like to use one for some clients and the other for others. I will utilize all of the columns in one and many fewer in the other.

Thanks for your help.

Hank

[Steve]

ErgoMan:

Can I use two different apps off the same data sheet?

Yep! This approach is common.

[ErgoMan]

I just ran into an issue. Got an error. The workflows I have set up just went into error. I added a colums towards the beginning of the spreadsheet. After I regenerated I got the errors. I have checked and the column is still there but the title in the Google Sheet is now blue? I have rewritten it and regenerated several tiemes. Still error. Thoughts?

Thanks,

Hank

[ErgoMan]

It is saying:
Workflow rule ‘Client Report’ action ‘Action 1’ AttachmentName template. Expression ‘[Employee Name:]’ is invalid due to: Unable to find column ‘Employee Name:’, did you mean ‘Employee Name’?.

The colum name was not changesd and is still there. The action does not refer to that column either.

[Steve]

Please post screenshots of both the spreadsheet that includes at least the header row of the problem columns, and of the error message displayed by the app editor.

[ErgoMan]

I guess I somehow turned it blue but of course it had no bearing on the error.

[ErgoMan]

Ok Resolution. I somehow deleted a : after the name that threw it all into error.

Thanks,

Hank