I have a table with a large amount of data per record. When the user goes to make their daily task (a form that makes a new record) I need them to see the blank form that has yesterdays submission pre-populated in it. The user then merely has to make todays edits and save it.
Parameters: 126 x 3 fields need to be brought over to the new daily form, 2 checkboxes and 1 255 Text field.
Known Issues: there is a 32k limit on passing external parameters from one datapage to another.
What I have tried:
Made a Report Details page that can find yesterdays submission and load it all as HIDDEN, then set the fields I want to move to the next Datapage as OnExit Parameters. Current issue is I need to automate the UPDATE button on the report page so users don't have to hit it to continue to the actual submission form. Second issue is that if there is a LOT of entries in that particular record, it can exceed the 32k limit and then a lot of fields get dropped.
I would appreciate any ideas on a better method or how to fix the issues....
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
sfraden
What I need to do:
I have a table with a large amount of data per record. When the user goes to make their daily task (a form that makes a new record) I need them to see the blank form that has yesterdays submission pre-populated in it. The user then merely has to make todays edits and save it.
Parameters: 126 x 3 fields need to be brought over to the new daily form, 2 checkboxes and 1 255 Text field.
Known Issues: there is a 32k limit on passing external parameters from one datapage to another.
What I have tried:
Made a Report Details page that can find yesterdays submission and load it all as HIDDEN, then set the fields I want to move to the next Datapage as OnExit Parameters. Current issue is I need to automate the UPDATE button on the report page so users don't have to hit it to continue to the actual submission form. Second issue is that if there is a LOT of entries in that particular record, it can exceed the 32k limit and then a lot of fields get dropped.
I would appreciate any ideas on a better method or how to fix the issues....
Steve Fraden
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.