1
0
-1

Hi. I made an app to our company that basically does a simple error report/management. I have 3 forms one for reporting a problem, one for investigating and one for fixing it. When you get a role in investigation/fixing you can see the previous forms as every form has a sub form before it. I also have in the user view a CRUD where you can view the forms when clicking on the edit function. However my issue is that the edit button says "Record cannot be found" if i click on a form that is not the one I selected in the CRUD. So if someone creates a new form and it has not been investigated you can't see it if I set form3 as the form that could be edited (view only). My simple question is how can I make it available to see the forms in detail in all the 3 steps of the process? There's no authentication or anything special about the process, just sticking to the basics.

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      Looks fine .- next step would be to create a list or two  based that table, with the appropriate columns... 

      Then you would place that list on the app menu and select the different forms you want to use for editing to match the user. 

       

      1. Adam Papp

        My end goal would be to have a View button that would let someone view the forms regardless of what stage it is in, in the main CRUD. I have tried just using the #form.formname.dataname# custom html like it is used in the isr request app but it says the same record can't be found error.

      2. Anders

        When using the https://dev.joget.org/community/display/KBv6/Hash+Variable#HashVariable-FormDataHashVariable, you may need to manually specify the recordId eg #form.tableName.fieldId[recordId]# if the data in the table is referenced using a different primary key from the record in the main form.

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

      I saw that in the expense claim app, but to me that was a bit over my head. This is what's inside of one of the fields: ##form.j_isr_request.ref_id#: #form.j_isr_request.subject# Can you help me understand what's the context? I'm not a programmer, so this is a bit high for me. Is this supposed to input the ID number from the form and the username into one field? Also how can I make a joint table that works correctly? I tried a few times before but I'm unsure if it worked. How should I post a layout of my forms? Here's a pic of it:

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

        Hi Adam if you are using the same table for all three forms, you would need an Id for the records that all three form can identify. The list would display the records that way as well.

        Can you post the forms layout?

          CommentAdd your comment...