Hi, there. I started to create an App for tools.I need to set a new column in the data sheet, when a certain action takes place. E.g. when I press a button, I want date and time stamp in the column “given away”. When the column does not exist in the data sheet, I need the app to create it. If existing, I want to use the existing “given away” column.
I do get the Data sheet without a few neded colums and I dont want to change the data every time, I get a new excel file. So, when I press the button and the column is missing, I want the action to create it oder, if it isalready available, I want the app to use it. Hope I could make clear, what I need, I am no english natvie speaker.
Regards Markus
P.S.: Edited for some mistakes
Glide actions can not create a new column. You can create your data set with all the possible columns you can think of and then set your actions accordingly.
2 Likes
Thank you for your answer.Then I need to change the Data file in advance, before I import it. Got to get this automated then.
You can also add columns to your table directly in Glide’s Data Editor.
I know that, but I wanted it to be automatic.
Every time, new Data is provided (which comes als xls file), some columns are not included. I would have to include the columns by hand and hoped, I could just import the xls file and the columns would be added, when needed the first time.
That’s actually what should happen - have you tried?
The thing is, you would still need to configure the layout to work with those new columns. That won’t happen automatically.
1 Like
You’re right - I did not think about this - I cannot configure the laou without the right column. Problem not solved, but I need another way anyway 
Thank you!
could he transpose his dataset so that he can add the data as rows instead?
Perhaps, I don’t know. I’d need more information to answer that.
1 Like
it is then easier for me to add the columns - changes to be made are mor dificult, than just add the columns