Organize the result count system
Hello, I need help to organize the result count system
In table «GM TABLE» in the Tab «tables» we create table with name (1, 2, 3 ...), prescribing the number of a certain number of chips on the table. Tables can be at 10 or more
These data are the basis for the invoice. Employees do not have access to it
Employee can only open ESTIMATION where specifies the date. Next open hourly estimation, enters the time and opens the following «Alltable3»
the task is - when I open «Alltable3» I should see this table, but each time with basis values.
New day is created in the main table «GM TABLE» with button CREATE NEXT DAY. Field data can change, we remove the style and create a new one with new data.
Attach DB for viewing
I'm unsure of the work flow you are describing for employees. I have to remember that when you talk about creating tables you are talking about gaming tables not DB tables. :)
In the Daily Estimation table are the employees supposed to create a new record every day with today's date? So each employee creates a record with today's date? Do you need to track the creation of days for each employee?
I'm thinking that a dashboard would be a possible good solution for this. My guess is that you don't need a history of the days, you just need a form that allows the user to select a day that will then be used to get data from other tables in your DB.
I'm not sure how the Hourly Estimation table works. You enter a time but your AllTables3 doesn't have any field that tracks time. I see that there is date/time field in AllTables. Does AllTables get updated hourly so there is data that can be filtered hourly?
Again, if you don't need to track hourly estimation then using a dashboard is a great way to allow users to input data that can be used to filter data.
We have one problem, if the next day we change the data of the Alltables in "GM TABLE", then they remain the same in the table. Therefore, it is important for us to tie them to the date GM TABLE
Yes that is the limitation of copying the data over.
Have you considered just creating a formula field that points to the appropriate field in AllTables? So when you make a change in AllTables it gets referenced in all other fields that point to it.
it is possible to display all data from Alltables to tables1 depending on the date, not using "View"?
It is possible. You just need to create a formula field that points to the field in AllTables.
An important note is to not use a select statement in each field. Too many select statements are bad. I would recommend you create a formula field called gatherAllTables and put something like this in the formula:
let t := this; first(select AllTables [Date = t.Date])
You can put this field in another tab or hide it by matching the background color.
Then create other fields that pulls data from this field.
If you wanted to create a field that showed you 'Sum chips 1' then you would put:
gatherAllTables.'Sum chips 1'
You would continue to create new formula fields for each field you want to show.