Input Fields

Check the type of input you want to show

Text

text.png

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 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
  • 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,.docx
    • image/*: all Images
    • video/*: all Video files
    • audio/*: all Audio files
    • A valid media type: you can check the complete list at IANA Media types
  • Multiple: Set to allow users to upload more than one file

Color

Select your cell and set it as input type color using the right menu.
  • Value: Set the Value of the field

Select

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
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 cell
Tip: Check validations here.

Datetime

Select your cell and set it as input type datetime using the right menu.
  • Value: Set the Value of the field
  • Placeholder: Field Placeholder
Tip: Check validations here.

Date

Select your cell and set it as input type date using the right menu.
  • Value: Set the Value of the field
  • Placeholder: Field Placeholder
Tip: Check validations here.

Time

Select your cell and set it as input type time using the right menu.
  • Value: Set the Value of the field
  • Placeholder: Field Placeholder
Tip: Check validations here.

Hidden

Select your cell and set it as input type hidden using the right menu.
  • Value: Set the Value of the field
  • Placeholder: Field Placeholder

Slider (Range)

Slider (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.