Handle input value in a repeatin group

[julian_ski]

Hello,

I have a page that I called Daily Sheet. The goal of this page is to make my user fill out a “form” of a fleet of vehicles each day. Each day, an operator goes around all the vehicles (the number of vehicles varies from one company to another). Each vehicle has a name. All vehicles must be checked on different mandatory control points (brakes, tires, lights, …).

I created this form in a popup.
In this popup, I have inputs for the date, the start time of the check, the end time, the name of the controller, … And I also planned to find all the vehicles (with their name) in a repeating group (but maybe this is not the right solution). For each vehicle, I will find my slidersinputs to indicate the brake condition rating, tire condition, …

I have a daily log database that includes the following points:

• General comment: text
• Controller: employee
• Date: date
• start time
• end time: date
• Company parameter: company parameter
• vehicle parameter: vehicle parameter
• Route: list of vehicle parameter
• day manager: text
• signature: text

I have a vehicle evaluation database with:

• brakes: number
• tires: number
• seat belt: number
• comment: text
• daily log: daily log
• vehicle parameters: list of vehicle parameters
• photo: file
• lights: number

I have a button to save my data.

The problem is that I can’t create the workflow or the process for creating the daily log that includes each of the notes for each of the checkpoints for each vehicle.

Every day I have to have a new sheet to record with all the vehicles and all the notes.

Can someone help me? I’ve been stuck for days or even weeks!

Thanks

[krenkel]

Hi, @julian_ski, I didn’t quite understand your request foHi, @julian_ski, I didn’t quite understand your request for help. I understood that you have two tables, but I didn’t understand the objective. In the example you gave, you have two different tables, with no connection between them.

[julian_ski]

Hello krenkel,

In fact, my goal is to have a sheet that summarizes all the checks of my vehicles, on each of the checkpoints.
Every day, I check each vehicle. And these checks are gathered in a sheet. So every day I have a sheet created.

Is that clearer?

[krenkel]

Hi, @julian_ski! So, I printed your question here and talked to my wife, to have a better understanding of your need. We identified that, for example, you have a menu, and there is a button called Car List, to open a repeating group and show the cars already launched by date, (for example), and in this list, you will have the option to click on the car model and/or license plate, and then, a pop-up will open, which will show only the name of the car, with the date for you to select and/or predetermined without the possibility of editing, and then all the fields that you have from these two tables will appear (we are just passing on the idea of ​​what we were able to extract from what you gave us). This way, there will always be a new sheet but only with the selected car and with the fields blank and then it will be filled in from another date, since it was already filled in from the previous day, then there are control items, if you are going to fill these in in text form and/or you will do a dropdown for the controller to choose the items that were checked, but in short, I believe that our vision is a little better now, would it be in this way?

[julian_ski]

I simplified my page. Here is what it looks like. Every day, an employee fills in the dropdowns as well as the date, time, …
And when he presses the button, it saves in PDF and stores this information.

[krenkel]

Bonsoir ici au Brésil - Itajaí - Santa Catarina.
Je vais le traduire en français, je crois que vous êtes français, non ? ; )

Allons-y par parties, je comprends que vous avez deux tableaux :
Tableau 1 - journal quotidien :
Tableau 2 - Évaluation du véhicule

Est-ce que tu aimerais avoir un panneau, où ça montre par exemple que la voiture, par exemple là-bas en France,
une Peugeot 208, plaque d’immatriculation xyz, à la date d’aujourd’hui : 09/12/2024 (jj/mm/aaaa) norme Brésil, avec l’évaluation de :
Depuis votre écran, les données du journal précèdent les données de la voiture.

TB_LOG_DIARY
Commentaire général : texte
Contrôleur : employé
Date : date
Heure de début
Heure de fin : date
Paramètre de l’entreprise : Paramètre de l’entreprise
Paramètre du véhicule : paramètre du véhicule
Itinéraire : liste des paramètres du véhicule
Manager du jour : texte
Signature : texte

TB_AVALIACAO_VEICULOS
Freins : Nombre
pneus : nombre
ceinture de sécurité : numéro
Commentaire : texte
Journal quotidien : Journal quotidien
Paramètres du véhicule : liste des paramètres du véhicule
Photo : Archives
lumières: nombre

D’après ce que j’ai compris, ce journal et l’évaluation deviendront un historique de cette voiture entrant dans votre entreprise, dans notre exemple : Modèle de voiture 208, marque Peugeot, plaque d’immatriculation xyz - identification préalable de la voiture, et nous devons remplir l’autre data , et avec cela, elles seront enregistrées dans la base de données, et d’après ce que je vois, elles sont dans des tables différentes, elles n’ont pas de clé étrangère, qui dans le cas de Bubble, fonctionne comme suit, nous avons la table de journalisation quotidienne , qui a une personne responsable, et nous avons la table évaluation, par exemple, nous aurions la table d’évaluation du véhicule, avec un champ comme le nom de la table du journal journalier, voici une simple connexion de la table d’évaluation à la table du journal quotidien. Avec cette communication, lors de la sauvegarde des données, vous aurez accès à la personne responsable de l’évaluation à travers une seule table, qui sera la table d’évaluation du véhicule. Je ne sais pas si vous me comprenez, mais sur cet écran vous ne me montrez qu’une pop-up à compléter, mais il n’y a pas d’écran avec les données déjà enregistrées par date et heure, puisque vous le ferez quotidiennement , vous devrez avoir un enregistrement par jour, et si vous avez l’enregistrement de la veille, vous contrôlerez cet historique (log) par date, plaque d’immatriculation, modèle, vous pourrez faire beaucoup de choses. mais pour commencer par date. Donc sur le bouton où vous avez d’anciens fichiers, je crois qu’il s’ouvre un écran avec une table et/ou un groupe répéteur qui va charger les données de la voiture évaluée, est-ce qu’il fait cela correctement ?

[krenkel]

Good evening @ here in Brazil - Itajaí - Santa Catarina.
I’m going to translate into French, I believe you’re French, right? ; )

Let’s take it one step at a time, I understand that you have two tables:
Table 1 - daily log:
Table 2 - Vehicle evaluation

Would you like to have a panel that shows, for example, that the car, for example there in France,

a Peugeot 208, license plate xyz, on today’s date: 12/09/2024 (dd/mm/yyyy) Brazilian standard, with the evaluation of:
According to your screen, the log data comes before the car data.

TB_LOG_DIARIO
General comment: text
Controller: employee
Date: date
Start time
End time: date
Company parameter: company parameter
Vehicle parameter: Vehicle parameter
Route: list of vehicle parameters
Manager of the day: text
Signature: text

TB_VEHICLE_EVALUATION
Brakes: Number
tires: number
seat belt: number
Comment: text
Daily log: Daily log
Vehicle parameters: List of vehicle parameters
Photo: File
lights: number

From what I understand, this log and the evaluation will become a history of an entry of this car in your company, in our example: Car model 208, Peugeot brand, license plate xyz - prior identification of the car, and we have to fill in the other data, and with that it will be saved in the database, and from what I can see, they are in different tables, they do not have a foreign key, which in the case of Bubble, it works like this: we have the daily log table, which has a person in charge, and we have the evaluation table. For example, we would have the vehicle evaluation table, with a field like the name of the daily log table. This is a simple connection from the evaluation table to the daily log table. With this communication, when saving the data, you will have access to the person responsible for the evaluation through just one table, which will be the vehicle evaluation table. I don’t know if you understand me, but on this screen, you are only showing me a pop-up that needs to be filled out, but there is no screen with the data already saved by date and time. Since you will do this daily, you will have to have a record per day. And if you have the record from the previous day, you will control this history (log) by date, license plate, model. You can do a lot of things, but to start by date. So, on the button that you have old files, I believe that there opens a screen with a table and/or a repeating group that will load the data of the evaluated car. Does it do this correctly?

[julian_ski]

Nice to meet you. Yes, I’m from Paris. It’s a pleasure to talk to you in Brazil. It’s OK to speak in english, i translate myself

Indeed, the ideal would be that on the page that I showed you in screenshot is displayed the history of the last control. That would save time.

On the historical part, the idea was not to open a repeating group but a PDF file that will have been saved before by clicking on my save button.

The whole difficulty is to have a repeating group that displays all the vehicles but only one input per control point to indicate the state of the vehicle. When saving, I can’t make my input (the one in my first line of the repeating group) multiply and capture the value of each of the lines.

So I tell myself that my method is perhaps not the right one.

I put a photo of my page under construction maybe it can help: a line with an input for the lights, an input for the brakes, … which multiplies according to the number of vehicles but with the name of the input which remains the same…

Do you think I should create a database per vehicle?
Maybe that would be easier for my workflow then?

[krenkel]

It’s a pleasure to meet you - my name is Nestor.
Good morning, I’m going to create a test project, and I’ll get back to you soon to see how we’re doing with this idea of ​​yours. But no, don’t create a database for each vehicle, you’ll have these two tables that you already have, this is a start. I’ll be back soon with something on screen. See you soon.

[julian_ski]

No problem Nestor, I continue to look for solutions on my side as well of course.

[julian_ski]

Hello Nestor,

were you able to look at my problem?

thanks

[krenkel]

Hi @julian_ski, still dwarf, have you made any progress?

[julian_ski]

Unfortunately I still haven’t found the solution. Every time I get the same result, taking into account only one car and not all of them…

[krenkel]

Hi @julian_ski, I’ll send you a printout in Excel, to see if this is what you want. That is to have a vehicle and keep the history of just one vehicle, but it’s in this idea, because I launch a car and then I’ll just launch its daily evaluations. And this will be for as many vehicles as you have. Is this the idea you want?

[julian_ski]

That’s it. And this information is contained in a sheet per day with the date, the name of the controller, a general comment, …

[julian_ski]

@krenkel

I’ll send you a printout in Excel, to see if this is what you want. That is to have a vehicle and keep the history of just one vehicle, but it’s in this idea, because I launch a car and then I’ll just launch its daily evaluations. And this will be for as many vehicles as you have. Is this the idea you want?

Like this :

[julian_ski]

The test score can be a number or a text, I adapt

[krenkel]

@julian_ski, I’m almost reaching the conclusion that we’ll need to use a repeating group within another, called a nested repeating group. But I’m going to do a test, because if I have some element from table B that talks to table A, it might not be necessary, since all the data will come from a single table. But now I think we’re getting a direction. I’ll let you know. Thanks for now.

[julian_ski]

I tried on my side with backend workflows but nothing works. Either I set it wrong, or there is another problem.

[krenkel]

Hi @julian_ski, now that I’ve made some progress, I didn’t use lists as I thought I would need to, but I needed to adjust the tables well, I even created one more and re-did the fields. Below are prints, I save the data, and search in the car model field, and two types of filters appear, one with just one car name, and the other repeating the name, but the first filter is more complete and it will add and remove information. Below are two prints already filtered to generate the necessary reports per car. As you can see, the dates change and there are the names of the responsible parties.