How can I pass time value from a configurable list to another field?

  • Profile Image
    vit.usela
    Asked on October 15, 2021 at 09:44 AM

    Hello, I was wondering how to pass a particular time entry from a configurable list cell and pass the value to another field i.e. table cell in order to calculate total hours? I am not sure how to address the particular time field from columns and also several rows if there are multiple entries.

    Many thanks in advance.

  • Profile Image
    Cecile_A
    Answered on October 15, 2021 at 10:12 AM

    Greetings,

    I did some tests but I do not think it's possible. Can you please let us know how you would like your form to work? Perhaps we could create a workaround.

    Looking forward to your reply.

    Thank you.

  • Profile Image
    vit.kettner
    Answered on October 16, 2021 at 11:10 AM

    Hello Cecile,

    thank you! In fact I need to build a monthly employee attendance sheet. It may be in a form of a table, however the input table does not have the date and time input cell types. So my idea was to pass values from a configurable list where there is a date and time type of input available. Configurable list provides the option to add new lines for e.g. several days of the month, but I was not able to get the individual dates and time values from each line to pass them to another field.

    There might be some template available but I was not able to find it.

    My demo form is available here: https://form.jotform.com/212862141380348

    I was just wondering if there could not be any better solution...

    Vít

  • Profile Image
    Patrick_R
    Answered on October 16, 2021 at 11:20 AM

    Hi there,

    Kindly note that the Configurable List widget's value can't be passed to any other field using conditions; it doesn't support this functionality.

    You can collect custom time values in the input table using general fields but the recommended way is to use the date time field only for this purpose. Date/Time calculations are only possible in such fields.

    If you have any questions, let us know.

    Thank you!