Hello everyone,
I am back to working my application, so I hope you all have your thinking caps on so you can assist me as I know I will get stuck in a million different areas **winks**
I am going to start with an easy question. I have my t_inv table setup with a field: inv_date. In the field rules I have this set as a calculated field with the expression: date()
Here is my problem: I want to be able to change that date in the instance where I am entering an invoice several days after the fact instead of it showing the current date that I am actually entering the invoice.
When using a calculated field you are not able to modify the entry ... so how can I have the current date set as the default value but still be able to modify it as needed.
WOW, I just answered my own question :) I cannot count the number of times I have resolved my own issues just by starting a post here and putting all of my detailed steps so others can help. Those of course I never actually post as I have the solution ... but I am going to leave this one solely for the purpose of a learning tool for others.
I resolved my issue by changing the field from calculated to user entered and on the data tab I set a default value of date(). This was so simple and many times just thinking outloud will give us our own answers.
The moral of this post: When posting an issue to the message board, including 'exact' detailed steps is critical to finding a resolution in the most expeditious manner. We all donate our time to help each other and learn more and more about this wonderful product. Anything that we can do to save the time of the person assisting us is simply common courtesy as all of our time is extremely valuable.
Moral TWO: Many times, while detailing the exact steps we are able to resolve our own issues :) Hence the post never makes it to the board in the first place and saves everybody their time :)
Cheryl
I am back to working my application, so I hope you all have your thinking caps on so you can assist me as I know I will get stuck in a million different areas **winks**
I am going to start with an easy question. I have my t_inv table setup with a field: inv_date. In the field rules I have this set as a calculated field with the expression: date()
Here is my problem: I want to be able to change that date in the instance where I am entering an invoice several days after the fact instead of it showing the current date that I am actually entering the invoice.
When using a calculated field you are not able to modify the entry ... so how can I have the current date set as the default value but still be able to modify it as needed.
WOW, I just answered my own question :) I cannot count the number of times I have resolved my own issues just by starting a post here and putting all of my detailed steps so others can help. Those of course I never actually post as I have the solution ... but I am going to leave this one solely for the purpose of a learning tool for others.
I resolved my issue by changing the field from calculated to user entered and on the data tab I set a default value of date(). This was so simple and many times just thinking outloud will give us our own answers.
The moral of this post: When posting an issue to the message board, including 'exact' detailed steps is critical to finding a resolution in the most expeditious manner. We all donate our time to help each other and learn more and more about this wonderful product. Anything that we can do to save the time of the person assisting us is simply common courtesy as all of our time is extremely valuable.
Moral TWO: Many times, while detailing the exact steps we are able to resolve our own issues :) Hence the post never makes it to the board in the first place and saves everybody their time :)
Cheryl
Comment