-
FMMS_ChangemakerAsked on March 6, 2020 at 9:51 AM
Is it possible to add a date column within a table i.e the person inputting the data has the option to select a date, or input the date in a set format (same as if they the field was just a date field)
-
Richie JotForm SupportReplied on March 6, 2020 at 11:05 AM
May we know if you're referring to the input table?
Currently,it is not possible to add a datepicker or calendar field in the input table.
Here is a screenshot of the available fields you can add in the input table.
Hope this information helps.
-
FMMS_ChangemakerReplied on March 6, 2020 at 12:51 PMThanks, I have created a table and used a textbox field for the inputter to
add a date, however the field records as text not a number and therefore
when I tried to add a formula that works out the time between two dates
(one being a date picker field and the other the text field on a table) it
records an *Error* - "function value 2 expects a value. But the "21/9/17"
is a text can cannot be coerced to a number"
43,870.00
#VALUE!
... -
John Support Team LeadReplied on March 6, 2020 at 2:24 PM
You were right. The dates entered in a textbox inside the Input Table field is treated as TEXTS. Note that there is no option to add a date picker field in the Input Table, and calculating time and date differences will only work with Date Picker fields.
I suggest creating separate Date Picker fields to be able to capture the dates that will be used in a calculation.