Duplicate Entries - Based off number input

[francois4]

Hi there Bubblers!

I please urgently require assistance.

My goal is to enter a ‘date’, select a ‘Drill Rig’ from a dropdown and enter the number of holes drilled.
The reason for this is that my database that displays the graphs is set up in this way.
Here’s a screenshot of the idea. So the user will only type in the fields in Yellow.

What will be the most effective way to enter the hole depths by being able to hit ‘Enter’ to go to the cell below, to speed up the capturing of the data.

Kind regards
Francois

[jobs]

Fake it

They will all be the same date.
They will all be the same drill rig.
They will all be sequential in number.

So I’d display what you have on the screen to the user, but don’t create the data yet. Create the 3 fields up top, and then a list of Hole depths.

When user hits submit at the end, backend workflow creates data based off of the list of holes and the 3 top info.

This would be super quick front end and only require the user to press “Save” at the end.

You can get the “enter” functionality by using a workflow when enter is pressed:

[francois4]

Hi Jobs

I appreciate the reply!
That would not work ideally in my specific situation. There are actually additional fields that will need to be added. That was a simplified version.
So after the data is submitted, I was going to display the data in a repeating group / table, with an additional blank Cell, so that the user can select the Drill Bit serial number that was used in a dropdown per hole.