I'm trying to count / add fields from a submission table to another table of unique people joined by a common person ID (each submission is tied to a single person but has about a dozen data points associated with it). I've figured out how to change the status of the submission from Pending to Valid once the seven days has elapsed, but I can't figure out how to add the new data to the person record. This is one of my attempts below (tied to record update in my submission table).
I saw some other issues close to this but I couldn't get any of the solutions to work for my situation. Thanks for any help in advance!
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
jerrym
I'm trying to count / add fields from a submission table to another table of unique people joined by a common person ID (each submission is tied to a single person but has about a dozen data points associated with it). I've figured out how to change the status of the submission from Pending to Valid once the seven days has elapsed, but I can't figure out how to add the new data to the person record. This is one of my attempts below (tied to record update in my submission table).
I saw some other issues close to this but I couldn't get any of the solutions to work for my situation. Thanks for any help in advance!
Link to comment
Share on other sites
1 answer 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.