Hello guys.I posted this but I don't know why, it disappear!
I am wondering to know if I can dynamically create a new collection with its table's name like a variable.
I am asking this because I am losing faith on create an inteligent app. I have posted something to try to solve this before, but no solution. The thing is: I want to use the add new data function from PowerApps to create a new collection as much as I need, linked to a costumer that I had added before.
I work at field doing Field Test Boring. My machine works basically like this: There is a hammer that falls in a rod boring the soil. I record the number of blows (N10) to this rod penetrate about 0,1 meters (ZN10). It can penetrate 15 meters, so I have 150 lines of information to record every Test.
I have already created an app that collect those information, but It do not works so good. I have 6 tables in Excel with some pre defined things and I use it as data source. I have an addicional table to the costumer information. So I can't link costumer to the Field Test Table. I have 6 buttons that navigates to the subsequent table.
What I thougt. If there is a way to dynamically create a collection (using add button in costumer information gallery), I can save it in mobile or tablet cache (local cache) and, instead of using Excel as data source, I just create an CSV file that I can convert in .xlsx when I have connection.
Justo to be clear. I can do more than 1 test per costumer, so to the same costumer, I would link more than 1 field test boring table.
Attached, there are some screen shot of my situation. (Furo=boring)