Input Fields
Check the type of input you want to show
- Text
- Number
- File
- Color
- Select
- Select Linked
- Select Multiple
- Datetime
- Date
- Time
- Hidden
- Slider (Range)
- Validations
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 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
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
- Use Search: Add a search input on select
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
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
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
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
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)
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 |
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.