0

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…

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 5 mths ago
    • Reported - view

    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.

    Like 1
    • Fred
    • Fred
    • 5 mths ago
    • Reported - view

    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.

    Like 1
      • Gianluca
      • Gianluca
      • 5 mths ago
      • Reported - view

      Fred That makes a lot of sense :)

      Now let's say these working times change from year to year and I want to be able to see what was my working time in 1995. I guess the only way to achieve that would be to create another table for historical data where data that I insert must be copied (maybe with a button and some kind of loop or automagically in some way....)

      Am I right?

      Like
    • Fred
    • Fred
    • 5 mths ago
    • Reported - view

    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.

    Like
Like Follow
  • 5 mths agoLast active
  • 4Replies
  • 40Views
  • 2 Following