6 Replies Latest reply on Mar 18, 2015 8:45 PM by Rahul Priyadarshy

    Need to add the manual entry in Table field

      Share This:

      Hi Guys,

       

       

      Need an urgent advise.

       

       

      Having a requirement where we have a table with many entries.

       

      lets say table has 3 cloumn    emp num, Name ,Result

       

       

      now we have many records with emp num, Name , but the result has to be filled by user.

       

       

      Emp NumNameResult
      123AB
      234ad
      456Da

       

      now below that we have dropdown field 'OutPut' having values Pass/Fail.

       

      User select first record and select the let say Pass, and try to save the record..the system should ask to fill all the results for all the records before saving the records.

      User will go to second record ,again select the pass or fail then third record.

       

      until and unless users fill the results of all the 3 records he should not be able to save the records.

      system should the user to save the form only if the table will look like

       

      Emp NumNameResult
      123ABPass
      234adFail
      456DaPass

       

       

      Can you please guide to achieve this ?

       

      BR,

      SK

        • 1. Re: Need to add the manual entry in Table field

          First Find the Total No of Records To be Updated in Table (here lets say Rec_Count=3 as per Your Example)---> You can use ColCount . Re: How can i get the Table Row Count ?

           

          Now Check the No of updated Table records with this Rec_Count and do untill its equal to Rec_Count and then Enable Save Button for saving the whole transaction.


          Also explore this from BMC Document--Using drop-down menus in list view tables where you can have PASS/Fail Value as drop down in the table Column itself.


          Updating tables on-screen only-  refer BMC Document...

          AR System application developers can create workflow that temporarily adds or deletes rows in list view, tree view, and cell-based tables. This workflow affects onscreen tables only and does not require calls to the server, which improves performance. Both users and workflow can interact with these temporary changes as if they were permanent. To make the changes permanent, developers can create

          table loop guides to commit the changes to the AR System database.


          Regards

          RP

          1 of 1 people found this helpful
          • 3. Re: Need to add the manual entry in Table field

            Hi Rahul,

             

             

            Now Check the No of updated Table records with this Rec_Count and do untill its equal to Rec_Count and then Enable Save Button for saving the whole transaction.


            how to check this this?


            user will select the pass/ fail from the dropdown field outside the table



            Thanks,


            SN



            • 4. Re: Need to add the manual entry in Table field

              Hi SK,

               

              I have a question here for you...

              In Table Field too you have Column to Store Pass/Fail? You also have a Field outside of Table Field for Pass/Fail, now how you are connecting the Table Field record with the Parent Record of the Main Form where table field is displayed?

              if you have a key here to connect these two records then ..You have the counter here.

               

              Table Record 1-  in the main form you selected the Pass/Fail and pushed this value to corresponding table record- Counter1.

               

              Same you will follow for other records..

               

              Regards

              RP

              • 5. Re: Need to add the manual entry in Table field

                Rahul,

                 

                 

                The table gets populated with a form back end ,wherein Emp, NumName values/records come from that form in the table and now we left with Result colum,which we need to fill manually.

                 

                Dropdown is outside the table ,let say i select Pass for the first entry and click on save ,pass will set to Result Coulm for first record[all 3 column records get pushed back to backed form].

                 

                If there is only one record then the record will get saved or else system will ask to fill the results for other records in the table.

                 

                 

                Hope you get it.

                 

                 

                Please suggest.

                 

                SK

                • 6. Re: Need to add the manual entry in Table field

                  Dropdown is outside the table ,let say i select Pass for the first entry and click on save ,pass will set to Result Coulm for first record[all 3 column records get pushed back to backed form].---> All 3 records Pass/Fail should suppose to be Filled .

                   

                  In My previous Post I suggestd to Explore On Screen Update in table Fields and then Commiting all in One Transaction. May be you can explore more.

                   

                  By Using counter we  can force users to fill pass/fail 3 times by forcing on Close button of that form , but its not a good way.

                   

                  Regards

                  RP