# Je voudrais pointer des employers et calculer leurs heures de travail

Bonjour !
Je voudrais créer une app de pointage mais je n’arrive pas à bien organiser la data : il faut organiser les données de sorte à ce que la date de début et de fin soient sur la même ligne. Je voudrais aussi assigner plusieurs personnes sur un chantier. Pourriez vous m’aider ???
Thanks !

Here’s my suggestion:

• Setup user profiles: Glide • User Profiles

• Create a tab for “Clocking in and out”

• In your User Profiles table, create a math column called “Today value” using this formula:

YEAR(D)*10000 + MONTH(D)*100 + DAY(D)

With D being the “current date/time” value.

It would give you a number like this: 20230625 to represent the current day.

• Create a “Clocking” table to store the clocking data. It would contain: User ID, Start time, End time.

• In the “Clocking” table, add a math column called “Date value” with the formula:

YEAR(D)*10000 + MONTH(D)*100 + DAY(D)

With D being the “start time” value.

• Back to the User profiles table, create a template joining the user’s rowID with the “Today value” column. It would look like this: idABCDEF - 20230625.

• Go to the “Clocking” table, add a template column joining the User ID and the “Date value”.

• Create a relation from the user table to the “Clocking” table using those 2 columns above. Make it a single relation.

• Add a lookup column on top of the relation to get back the “End time” value.

Now, on the front end, in the “Clocking” tab, add a button that says “Clock in”. Show that button only when the relation above is empty.

The button would add a row in the “Clocking” table with the signed-in user’s rowID and the current time written to the “Start time” column.

Add a button that says “Clock out”. Show that button only when the lookup “End time” column in the user table is empty.

That button would have a set column action writing through the relation, setting the current time to the “End time” column.

1 Like

For assigning users to constructions, add a construction table with the construct name, description, etc.

Add a text column named “Assigned IDs”. On the add/edit screen of the construction, add a choice component pointing to that column, allowing you to choose from the Users table, writing the rowID of the users but showing their names on the front end.

Next, add a split text column to split “Assigned IDs” by a comma.

Create a multiple relation from the split array to the rowID column in the Users table. You will then be able to show a collection of assigned users for each construction site.

On the users table, you can create a multiple relation from the rowID column to the split array column in the Constructions table to show users the construction sites they are assigned to.

Thank you so much !!

1 Like

Sorry, I don’t really understand this instruction
Here is the link to my project : Work Order Management · Glide (glideapps.com)

May you help me to achieve this project ??