We're performing a big move from excel based "databases" in to a proper Caspio database.
We store a lot of customer information such as address. We'd prefer that our customers send us an e-mail to update their address information. However since we're transferring such a large number of users we'd like to give everyone the opportunity to update their data once without e-mailing us.
I've created the update form for users, and created an additional field called "CaspioUpdate" in our table to mark whether or not that user has completed the update form or not. My rules on the form appear to work and do not allow the user to update their information if it finds data in the CaspioUpdate column for that user. The trouble I am having is having the CaspioUpdate column update AFTER the user has complete the form. How can we do this?
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
Scott42
Hello,
We're performing a big move from excel based "databases" in to a proper Caspio database.
We store a lot of customer information such as address. We'd prefer that our customers send us an e-mail to update their address information. However since we're transferring such a large number of users we'd like to give everyone the opportunity to update their data once without e-mailing us.
I've created the update form for users, and created an additional field called "CaspioUpdate" in our table to mark whether or not that user has completed the update form or not. My rules on the form appear to work and do not allow the user to update their information if it finds data in the CaspioUpdate column for that user. The trouble I am having is having the CaspioUpdate column update AFTER the user has complete the form. How can we do this?
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.