I want to enter several records at a time, like the repeating section in a UX, but I don't want it based on a one-to-many table; I'd like it based on the top-level one-to-one table. Maybe it might be best to use an "Add records only" Grid, but a Grid doesn't give me the flexibility for easier data entry like a UX component does-- at least I don't know how to do it in a Grid if it does.
What I'm attempting to do is build a Time Sheet for payroll entry. I created a UX with the employee as the top-level and the hours entered as the one-to-many table, but I'm getting a few errors. This is where I am:
2019-02-13 Labor Hours with error.png
The User enters the default employee and pay period above, and those become the defaults for the repeating section entries. The error I got in my first attempt is shown in the top part of the image...it's an error in the a5DialogHelper_Execute_CRUD_Statements() function, which I assume is a built in function that creates the SQL INSERT statement.
I decided to start over fresh, creating a more simplified UX, but then I got a different error. That error is shown in this image:
2019-02-13 Labor Hours2 with error.png
That's when I figured I was attempting create a one-to-many in a way alpha couldn't handle. Maybe it's because I'm attempting to "append" to an existing one-to-many. I don't know... That's when I decided to go back to entry from a Grid. It works, but I don't know how to create the defaults that would make data entry easy and less prone to error.
Is there a better direction to go? Where can I look to fix these errors, if they can be fixed?
What I'm attempting to do is build a Time Sheet for payroll entry. I created a UX with the employee as the top-level and the hours entered as the one-to-many table, but I'm getting a few errors. This is where I am:
2019-02-13 Labor Hours with error.png
The User enters the default employee and pay period above, and those become the defaults for the repeating section entries. The error I got in my first attempt is shown in the top part of the image...it's an error in the a5DialogHelper_Execute_CRUD_Statements() function, which I assume is a built in function that creates the SQL INSERT statement.
I decided to start over fresh, creating a more simplified UX, but then I got a different error. That error is shown in this image:
2019-02-13 Labor Hours2 with error.png
That's when I figured I was attempting create a one-to-many in a way alpha couldn't handle. Maybe it's because I'm attempting to "append" to an existing one-to-many. I don't know... That's when I decided to go back to entry from a Grid. It works, but I don't know how to create the defaults that would make data entry easy and less prone to error.
Is there a better direction to go? Where can I look to fix these errors, if they can be fixed?
Comment