I have a form with a DA_Name field, a Request_Date field, and a Processing_Date field. The DA_Name field is a pop up sleect list. The Processing_date field is a text field where you can input a date.
- The Request_Date field is actually queried from another view upon selecting a specific DA_Name.
- i.e....if you select Ben as the name, it'll return Ben's corresponding request_date.
- This query is controlled by a dynamic action
However, there are some names that don't have a corresponding request_date, so it just returns a NULL value to the form. I have made this field a text field as a date picker. When I select a name that returns a NULL value, I want to be able to type in, (or pick the date - date picker) the date.
Even when a date is returned from a a name, I would like to to be able to change it if need be. Everytime I try and do so, it doesn't capture or save what I typed in. Any suggestion on how to handle this
There may be nothing wrong with the value selection behaviour, rather what you're doing with the request date field once the page is submitted.
Is the date value at least being set in session state?
What are your source attributes?
The source used of the Request_Date is on "Always, replacing any exisiting value in session state". I had changed it to, "only when current value in session state is null, and still had no luck. The source type is on "Database Column".
Also, there is no default value set