We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3244543
limitering aan frontend edit invoer waardes
Closed

Comments

  •  1
    Jouke started the conversation
    March 2, 2023 at 10:29am

    Kan ik de waardes die de gebruiker in de frontend kan aanpassen beperken ?

    bijvoorbeeld hebben wij een kolom in onze tabel met een percentage van 0-100. ik wil dan dat de gebruiker een getal tussen de 0 en de 100 zou kunnen invoeren. en het overige zal worden genegeerd.

    as the form is in dutch i doubt the fact that your support also is dutch so here in english ;-) 
    Can I limit the values that the user can change in the frontend?
    for example we have a column in our table with a percentage from 0-100. I then want the user to be able to enter a number between 0 and 100. and other numbers are ignored.


  •  1,894
    Miloš replied
    March 2, 2023 at 5:17pm

    Hi, Jouke.

    When it comes to setting up available values for Editing with our built-in options,

    for String Columns,

    you can go in a column's settings/Data tab,

    and change from 'Read from table on page load' , to 'Define values list' or 'Use values from another wpDataTable ( foreign key)'

    5088843840.png

    If you set to "define values list",

    then you can set  any values you need, and only those values will be available,

    but for Editor Type, for this to work - you can set "Single value selectbox", or "multi value selectbox".

    1319740214.png
    4028492215.png

    Then, if i try to edit existing value for that column,

    it only allows me to pick from defined values.

    4586228402.png

    -

    Or if you make a Foreign Key relation with a column from another table; 

    in that case it will pull all the available values from that other table's column.

    So if you set up only values you need there ( for example between 0 and 100)

     - the user is limited to only a 'single value selectbox' Editor Type, 

    and they can only choose from values you set in that other table's column.

    -

    Let me know if that helps.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

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

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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