it means you have not taken the text of the dynamic component id, instead you have taken only the id
no , you have not used the dynamic component
here use the id, instead of label use text box
In fact, my goal so that you can understand more easily, I would like to count the number of hours spent for a client (for my work).
Example, the litpicker contains all the names of the customers.
Textbox 1 will contain the type of work (on a machine, paint, labor, etc.)
Textbox 2 will contain the number of hours (I think to change it by a time selector, it will be maybe more ergonomic than the textbox);
And a button which validates, and which saves me the data. I already have a database that works, but is not practical, I record by date, my arrival and departure times, but I want to improve the customer part.
@Still-learning Here is to schematize, the tree structure of what I want to obtain
So, I used Airtable because I find it easy to use, but if there is something else more practical for my purpose, then I will change my method! With Excel for example (or GoogleSheet?)
With the possibility of having several different customers in the same day, obviously, I did not put it on the diagram, but the Client Name cell could be present several times during the day
If this is your airtable structure, here how will you add the text box 1 value and 2 value? and what is the use of clicking the button to add pair of text boxes? sorry i am very week in understanding
I have trouble explaining myself too, because I use Google Translate ^^
Iāll try to keep it simple, with examples:
-
Monday, I arrive at 8 a.m., I leave at 5 p.m.
For the AAA client, I did painting for 2 hours and manufacturing for 3 hours
For the BBB client, I did 4 hours of labor; -
Tuesday, I arrive at 8 a.m. and leave at 5 p.m.
For the CCC client I did 9h of labor -
Wednesday, I arrive at 8 a.m. and leave at 5 p.m.
For the AAA client, I painted for 3 hours
For the DDD client, I painted for 4 hours
For the EEE client, I did manufacturing for 2 hours
Etc ā¦
So each data (current date, arrival time, departure time (+ calculation of total time), name of the client (+ a dedicated number), type of work and working time), I would like to save them every day in an easily searchable table
A relational database.
Customers - Customer Information
Service Provider - Service Provider Information
Services Provided - save the services provided (service types table) by the service provider (service provider table) to any customer (customers table), on a date, with beginning and end.
Types of Services - Information about the service.
You should know that this application is just for me, so that I can enter all this information and have a visual to fill out a sheet of paper for my employer.
I did a basic project in aia, so you can understand the overall meaning of what Iām looking to do, here it is:
test_hour.aia (10.0 KB)
Itās very basic on this aia, but what I would like is that:
- when I chose a client, I can add as many 6.1 and 6.2 (you did this in your last example)
- When I click on the āValidate Allā button, in the card at the bottom, for each customer, it adds a line in the horizontal scroll arrangement. And that the information is recorded somewhere, in a clear way, so that I can consult it whenever I want.
But if you think like this :
Iāll have a bigger job but the app will be more complete.
You will have your app (service provider)
and the boss will have his app, where he will be able to see the worksheet of all the services of all employees
It might be a great idea, but for me it would be too much.
I canāt explain myself, itās complicated via Google Translate ā¦ But I try to write down all my working hours of the day so that I can consult them later. And add options such as customer / site number, customer / site name, type of work and number of hours performed for this type of work and for each customer / site
Yes I understand.
But then, you want to fill in this information so that you can easily consult it later.
No doubts, I will answer you with 100% certainty:
use sqlite
Sqlite ā¦ Hmm, still something new for me, Iāll try to see this
Create a screen with the services listed.
On this screen, create the buttons with the functions - new service - edit service - delete service.
and create queries: by date, by customer, by service provided.
@plumedours here , exists aia example
You are creating a useful app ( I appreciate these types of apps )
So, try Sqlite and any questions post here or create a new topic.
Thank you very much, I will study all this, and if I have any questions I think I will do a new topic dedicated to this
Hmmmm, i donāt think, this kind of pattern you can create with your design. Because you cannot design blocks to create row with your designā¦
If you want then in each row you need to add the same details for every 6.1 + 6.2 row values.
It means
Row 1, date, name, arriving time,departure time leaving time, type of job, working hours
Row 2, same thingsā¦
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.