Speeding up data insertion
Hi again 
is it possible to insert data without repeating those that have to stay fixed (for a few lines, but not for every line).
To explain better, let’s say that I have a table for the working times (named ‘Times’) of a person (whose personal data are in a table named ‘People’ linked to ‘Times’) and let’s say this person (Gianluca) works :
monday 9am to 11am
monday 2pm to 5 pm
Tuesday 9am to 11am
Tuesday 2pm to 5 pm
…And so on for the whole week
While another guy (Andrea) works
monday 9am to 12am
Tuesday 2pm to 5 pm
…And so on for the whole week.
Being on the ‘Times’ table for every single entry I also need to specify which person those times are referred to.
Is there a way to choose the person and then keep inserting all of his working times specifying his name only one time ?
Like choosing Gianluca once, insert all his times
Then choosing Andrea once, insert all his times.
And so on…
4 replies
-
Since People and Times are linked you can start in People and there should be a create Record under the Times view. Any new Times record will automagically have the link to People.
-
I have a sport DB and I use to enter in data in my results page and I had to pick a year, a location, a team, a rider, a horse.
I eventually leaned that once I linked Location to Results, I can enter a record in the results table from the Location table and the location would already be linked since this was one piece of data that is constant so it saved me from.having to pick the same location 32 times.
-
Thinking off the top of head,
1) if you don't need to see historical data very often then you can just filter the Times view to show you the data you want.
or
2) you can use a dashboard that uses shows you all data related to a person. One view would be the Times view where you can then have another field in the dashboard where you can select a time. then you can show other data linked to a person.
Content aside
- 2 yrs agoLast active
- 4Replies
- 55Views
-
2
Following