Input Fields Check the type of input you want to show Text Select your cell and set it as input type text using the right menu. Value: Set the Value of the field Placeholder: Field Placeholder Input Prepend: Set any text on left side of the input Input Append: Set any text on right side of the input Tip: Check validations here. Number Select your cell and set it as input type number using the right menu.Value: Set the Value of the fieldPlaceholder: Field PlaceholderInput Prepend: Set any text on left side of the inputInput Append: Set any text on right side of the input Include controls: Check if you want +/- controls Tip: Check validations here. File Select your cell and set it as input type file using the right menu.Accept: This will be set if you need to limit files uploaded depending on type. You can set:File extension:.jpeg, .gif,.zip,.docximage/*: all Imagesvideo/*: all Video filesaudio/*: all Audio filesA valid media type: you can check the complete list at IANA Media typesMultiple: Set to allow users to upload more than one fileColor Select your cell and set it as input type color using the right menu.Value: Set the Value of the fieldSelect Select your cell and set it as input type select using the right menu. Sheet: Select the Sheet of your Excel file where the data of the select is. Range: Set the range in the Sheet selected above where XLSJuice will get the data. I.e.: A1:A20 Use Search: Add a search input on select Tip: Check validations here. Select Linked Select linked is a special kind of combobox. It automatically reloads its options depending on other combobox value. Find out how to configure: Select your cell and set it as input type select multiple using the right menu. Sheet: Select the Sheet of your Excel file where the data of the select is. Range: Set the range in the Sheet selected above where XLSJuice will get the data. I.e.: A1:A20 Use Search: Add a search input on select Parent: Set the Select input that will reload options for this Select.How it works: Once the user select the 'parent' input, the value will be placed at the right excel cell and current 'select linked' combobos will get data from your excel file in the sheet and range configured.When refreshing options it will exclude blank cells, so this will be used to discard unwanted options for each case. Write your formulas in a way the value will return blank if with that parent value you don't want to show that option, return the option text otherwise. Select Multiple Select your cell and set it as input type select multiple using the right menu. Sheet: Select the Sheet of your Excel file where the data of the select is. Range: Set the range in the Sheet selected above where XLSJuice will get the data. I.e.: A1:A20 Use Search: Add a search input on select Separator: This separator will be added between items selected in the spreadsheet cellTip: Check validations here.Datetime Select your cell and set it as input type datetime using the right menu.Value: Set the Value of the fieldPlaceholder: Field PlaceholderTip: Check validations here.Date Select your cell and set it as input type date using the right menu.Value: Set the Value of the fieldPlaceholder: Field PlaceholderTip: Check validations here.Time Select your cell and set it as input type time using the right menu.Value: Set the Value of the fieldPlaceholder: Field PlaceholderTip: Check validations here.Hidden Select your cell and set it as input type hidden using the right menu.Value: Set the Value of the fieldPlaceholder: Field PlaceholderSlider (Range) Select your cell and set it as input type slider using the right menu. Value: Set the Value of the field Placeholder: Field Placeholder In order to configure Slider properties you must add the following validations: step: The stepping interval max: The maximum value allowed min: The minimum value allowed For each validation you can configure also a validation message, but they won't apply to this field type because the slider is already configured with these limits, so no validation messages will appear. Validations Here are validations you can added to your inputs: Name Description Valid for Required Makes the element required text inputs, selects, checkboxes and radio buttons Email Makes the element require a valid email text inputs URL Makes the element require a valid url text inputs DateISO Makes the element require an ISO date text inputs Number Makes the element require a decimal number text inputs Digits Makes the element require digits only text inputs Minlength Makes the element require a given minimum length text inputs, selects and checkboxes Maxlength Makes the element require a given maximum length text inputs, selects and checkboxes Rangelength Makes the element require a given value range text inputs, selects and checkboxes Min Makes the element require a given minimum text inputs Max Makes the element require a given maximum text inputs Range Makes the element require a given value range text inputs Step Makes the element require a given step text inputs, number and range Equalto Requires the element to be the same as another one Tip: You can combine as many validations as needed. Form will validate fields once user clicks on 'Calculate' button.