Where is a Date Input Field's Value in Formula Builder?

Hi,

I have list container, which has a form container, which has a few input fields, including two “date and time pickers.” The other form fields show up fine, but the date fields are nowhere to be found in the formula builder.

After playing around, I discovered that if I move a date picker field outside of the ‘list’ container (and thus also removed from the ‘form container’) it will show up in the list of components.

Why can’t I place any date or time related inputs inside a ‘form’ or repeating ‘list’ type container? I must be doing something wrong, but I can’t figure out how to debug this–nothing I try seems to allow me to get date or time input values from inside this container.

Side note: I have the form + input fields inside this ‘list’ style container to make updating the entries easier. However, I’m also interested in your thoughts if there is a better way to do this ‘auto saving’ on input changes. Doing it across different types of fields at the same time proved to be tough–hence the manual ‘save’ button.

I solved this with the help of this thread.

Counterintuitively, on repeating item containers some input fields work normally, but others you must set your own variables for. I do not know the full pattern and which (or why) some form input fields work in this context and others do not, but no date related field seemed to work.

I had to create a variable and use ‘on input change’ workflows on my date fields to update it. Then when the user clicks the ‘save’ button, the workflow for saving it to the database uses the dates stored in the variable.

I was stuck on this for several days!

1 Like