Okay
  Public Ticket #3359370
Report builder (no datasource) variables field types
Closed

Comments

  • Kessy Juma started the conversation

    Hi,

    Is there anyway to specify the variable type so that if it's number, text input can not be entered and vice versa? When I view source, I can see that the input fields get type="text" by default.

    <input type="text" class="reportbuilder_input capitalize error" data-report_id="1" data-var_name="sharecapital" value="">
    

    How can I make it:

    <input type="number" class="reportbuilder_input capitalize error" data-report_id="1" data-var_name="sharecapital" value="">
    

    Regards,

    Kessy

  •  1,819
    Miloš replied


    Hi, Kessy.

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    I am sorry to disappoint you, but we are not able to change the HTML to say input type as "number",

    but if you make a numeric column, such as Float or Integer,

    our plugin will not allow a user to input anything but numbers.

    -

    You can try to make a numeric ( float or integer) column, and set Editor type as "one line" or "multi line" Edit;

    then if you add or edit a row - if you try to input any letters or symbols, nothing will happen.

    It only allows numbers for numeric data, even though it says "text" in HTML.

    7498878046.png

    So technically speaking, what you wrote at the beginning is the default behaviour, exactly like this :

    If you set Data Type as Numeric for any column, in any editing it will not be possible to enter any letters or symbols - only numbers are allowed.

    Let us know if that makes sense.

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Kessy Juma replied

    Hi Milos,

    Thanks for your response. I understand that once you set integer or float for a column then the cells in that column will not accept text. This is for report builder that has a datasource.

    Actually my issue is for Reportbuilder (NO DATASOURCE) as per the title of this ticket.

    Regards,

    Kessy

  • Kessy Juma replied

    Maybe the workaround would be to add additional column with data type options in the additional variables fields.

    PS: See attachment to get an idea of what I'm referring to.

    Attached files:  Reportbuilder additional variabbles settings.png

  •  1,819
    Miloš replied

    Hi, Kessy.

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    Thank you for the clarification, that was my mistake, now i can see what you meant, and it was in the ticket title as well.smile.png

    In the use-case without the data source, you are correct, at the moment, we still do not have the option to set up the data type like that for variables.

    It is a great idea to add this in the Report builder, thank you for this suggestion.

    5524576448.png

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables