1 2 Previous Next 17 Replies Latest reply on Mar 17, 2017 10:47 AM by ezeitgeist

    Adventure 2 EVS: Checkboxes with Scrollbars ... using a Virtual List?

    ezeitgeist

      I am trying to grasp a couple concepts at the same time ... the Checkboxes with Scrollbars setup and (maybe) Virtual Lists.

       

      Goal: Users can currently add meetings with Contacts. I would like to add a portal on a Users table layout that lists all the Contacts the User has thus-far added a meeting with, and allow them to check off any number of those Contacts to then run a script only for those specific contacts.

       

      Ex. A Batch Update ... Users have a list of Contacts they've met through meetings, they send a batch update (via email or the like) to some of those Contacts. ( I would then, through a script, create a new entry in an "Updates table" that creates a record for each checked Contact, associates the User_ID, and fills in a couple of fields.)

       

      My thought is that using the checkbox portal, I could allow users to check the Contacts they are updating (maybe it is all, or just part of their list), the user fills in a few global fields, and clicks "Save" and then I have a script that creates all those records based on the checkbox field = "1" (or the like).

       

      My understanding is that the portal utilized references a table that has a record for each item presented to be checked, with a field for the checkbox on/off. Could I just do a filtered portal of ALL Contacts and filter by User_ID AND not IsEmpty(Connection_ID)? [Connection_ID is the serial field when a meeting is created with a Contact]. Then could I just add a global field to the Contact records for the checkbox? THIS SAID, the Connections table has a User_ID, but the Contacts is a shared table among all the Users so those records do not have any User_ID associated. So maybe just "not IsEmpty(Connection_ID)"?

       

      TO:

      User Table <--thru User_ID--> Connections Table <--Contact_ID--> Contacts TO copy

       

      Meetings are created through a popover in Contacts Table that fills in globals and then creates a new record in Connections Table with a button.

        1 2 Previous Next