edit datalist values (i.e. checkbox, dropdown) directly from datalist w/o opening record

 
1
0
-1

I have searched the knowledge base and looked at the marketplace as well as the plugins and cannot find the answer to this. 

I have a datalist with containing records with text, date, text area, 1 dropdown and 2 checkbox options. 

i find it very inconvenient to have to click to edit the record in another screen and would like to be able to edit the values (the checkboxes and dropdowns are what I would really like to be able to edit) WITHOUT clicking on edit to open a screen. 

I found the datalist beanshell formatter and the script looks like it would work for this but when I enter it in on the datalist → formatter → beanshell screen nothing changes. 

I need it so that I am able to check and uncheck directly from the datalist screen and/or choose a different option in the dropdown. 

I am at a loss - how do I do this??

    CommentAdd your comment...

    4 answers

    1.  
      2
      1
      0

      It seems you are trying to do Data entry using a datalist. I think you need to use a Form on a grid instead of a datalist if you want to edit. If you have values that need to be retrieved from the database you should either use JDBC or Bean or Joget Form Bean to back your data retrieval and saving. 


      Looking at your screen short I think I get that you have some data that is saved in some table that you are trying to retrieve and then modify it on the main screen and preventing user from navigating to another screen for convenience. 


      As I mentioned you can convert a form's Grid into dropdown and text but I have not seen an example of converting a grid column into a checkbox but for that one I think a trade-off is to accept Yes and no Dropdown. .

      From your screenshot, it is clear that you are trying to do it in datalist. Datalist to my understanding is best suited for data retrieval and filtering joining etc. Forms are used for when you need to retrieve and modify. If you export and upload your app or its simpler version one might be able to provide some feedback.


        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi, thanks for your answer. 

        I do not want to do data entry on a datalist. I want the ability to change a dropdown value on a datalist that contains a dropdown without opening the record (because it causes quite a few additional steps). 

        I tried using a list grid on a form but instead of returning values, it is empty except for a weird square character, and then I have to open the record and still choose an option. At that time, it will return something that looks like this: {{value }}


        1. I have a form and on that form, I enter my data for my datalist
        2. On my datalist, my entries show with the data that was entered on the form
        3. Instead of an editable dropdown as I want it to be, it only shows the actual value entered from the form. I then have to click on "edit" or "open" to change the value of the option. 
        4. I would like to be able to change the value of this dropdown for these records
          CommentAdd your comment...
        1.  
          1
          0
          -1

          hi thank for your answer. I will have to read into that. 

          After  spending 6 hours on this instead of the 12 hours of work that I have to do, i was able to get a default value of "no" to show and it can be clicked on but I am unable to get it to change to 'yes' as i have in the script or anything else. 

            CommentAdd your comment...
          1.  
            1
            0
            -1

            You probably need to make a screenshot to explain your question. 

            I  think you need a List Grid that has data loaded that you can modify using the dropdown. 

            I have not seen updating a checkbox that can be displayed in a grid. I would love to see an example of that but drop down ina List grid is possible. Expense app have an example using the hidden form that have a list. 

              CommentAdd your comment...