0

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

Regards 

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    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.

    Like
    • Fred Thanks for answer 

      Partially the problem has been solved for now. We have created the subtable and when tables are created, the same subtable - Table1, is created in "Hourly estimation".

      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

      Like
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view
    ekalcasino777 said:
    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.

    Like
    • Fred 

      We considered, did it with "View", In this case, the result of the past hours is not fixed, they change when a new value is entered. 

      Like
    • Fred it is possible to display all data from Alltables to tables1 depending on the date, not using "View"?

      Like
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view
    ekalcasino777 said:
    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.

    Like
Like Follow
  • 2 mths agoLast active
  • 6Replies
  • 50Views
  • 2 Following