Delete columns, must remove fromGoogle sheet?

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!

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.

1 Like

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

Yep! This approach is common.

1 Like

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

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.

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.

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

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

Thanks,

Hank

1 Like