Spread-Sheet : Merge two spreadsheet on same page

 
1
0
-1

Dear Team,


I need one help, I have a one Joget form on this form taking 2 spreadsheet spread1 and spread2. e.g.

Spread1:

LYC
234
234




Total C8

Spread 2

MKP
468
234




Total C12


Problem: If spread1 Column C total value is in calculation hidden field display  and same value want to display Spread 2 Column P.


Either Once enter spread1 column C value auto SUM of Spread1 Column C values populate into the Spread2 Column P.


Please help me if any possibility appreciated

    CommentAdd your comment...

    4 answers

    1.  
      1
      0
      -1

      Remember that to use #form.table.fieldname#, the record must already exist in DB. You could try using #requestParam.id# if you have the record id in the url of the opened form.

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

        Thanks as per your advise, I was trying to use but it is not working.

        Let me explain again 

        Division List,  Once division select need to sub-division display into the spreadsheet column

        Spreadsheet: Under Scope of work column now showing 2 that is default value set but I want to select division based on that display the data .

        Query: Query I am trying to use on Spreadsheet JDBC Binder 

        SELECT c_sub_division as scopeofwork FROM app_fd_subdivision_profile where c_division='#form.ipadetails.division#';

        ipadetails: Current form table


        1. Matthew King

          As mentioned earlier, to use the #form....# hash, this value needs to be in the database, not currently edited form where you change the field value.

          Do try using instead the AJAX Subform where the spreadsheet sits in the subform and you link the subform to the selectbox field. And in your subform load binder, use this hash '#requestParam.primaryKey#' variable in your SQL WHERE clause. Using the Ajax Subform, you can then populate the subform containing the spreadsheet dynamically and in real time. There is a demo app in this KB page you can download to learn how.

        2. Ajeet Kumar Gupt

          Thanks Matthew , will check and let you know

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

        OK Thanks for the details, let me try to implement this.


        I need one more query related spreadsheet. Please guide me.

        I have a one form on the form dropdown in this dropdown LOV (department details) based on department 5 to 6 details are showing. I want to those 5 to 6 details showing in the spreadsheet first column.


        I am trying to use the JDBC binder in spreadsheet with select query where clause but unable to do it,  because in the where clause using  id='#form.table.fieldname#' but unable to find the hash variable values.


        Please suggest me.


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

          You could try using JDBC Options Binder in Load Binder, to read the DB table containing both spreadsheets values and use SQL to sum them before displaying in the form.

            CommentAdd your comment...