storing form value inside two list

 
1
0
-1

so basically for example :
i am adding a new product in the list called (products)

then i want some of the details in the products to show in another list called inventory

now this inventory will have same column which is not found in the list products

at first those value will be null then there should be and edit 

when i click edit it should allow me to insert the value of those empty column then.




summary : 

when I submit a form i want the data to be stored in 2 list 

1 list will have all the column I submitted in the form 
1 list will have some of the column in the form and some in different column
I want to show my data in a list even those different column currently hold no value 
(which I will then edit the list to take me to a another form to update those value)


    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      when you click the edit button, it should pass the id of the record in the URL parameters.
      if your list is combining data from 2 different tables, you should make sure that the id column that you want to pass is included in the List Builder. you can set it as hidden column.

      1. M Tarek Hamwi

        how do i pass id using URL parameters ?

      2. Aqilah

        you need to include the id column in the List Builder.

        in the CRUD Menu, when you press the Edit button to edit the data record in your form, it will automatically include the id in the URL parameters.

        say that your Form page URL is
        <baseURL>/jw/web/userview/<appID>/v/_/product_crud?_mode=edit&id=xxxxx

        the xxxxx is the id of your selected record data

      3. M Tarek Hamwi

        how can i pass that id from the first form to the second form ?
        would you mind sending a image on how it is done or a link that i can refer to 

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

      In Joget, lists are templates to display data. The actual data comes from your chosen datasource - forms, APIs, or SQL queries.

      For your case:

      1. Create two forms: app_fd_products and app_fd_inventory. This creates two separate database tables.
      2. Design both forms with relevant input fields.
      3. To collect both product and inventory details in one form while maintaining separate tables:
        • Use form grids or subform repeaters
        • These are suited for parent-child relationships like you described
      4. For viewing and editing:
        • Create 2 separate lists and select the forms you created as their datasources
        • You can also join them to show data in 1 list if needed
        • or use nested datalist. 

      Documentations:

      1. Form Grid 
      2. Multiple Form Row
      3. Nested List Formatter


      Hope this helps. 



      1. M Tarek Hamwi

        i made two form already 
        and I have two data lists.


         


        now this is my datalist 

        i want when i press edit to only edit those empty cloumn 


        basically if i have two form 

        1 form will contain the data trying and the date 
        the other form will have the two missing value

        the reason for this is because i want the user to actually input the data 

        so when he press edit it should take him to the form to edit those empty 

        but when i press edit it shows this 

      CommentAdd your comment...