2 Replies Latest reply on Jul 1, 2011 7:33 AM by AndreaPaulaner

    Auto enter records in a portal

    AndreaPaulaner

      Title

      Auto enter records in a portal

      Post

      Dear All

      I Have a database (product) linked with a Inventory log. I have also another table linked with the raw materials. When I start a new production, I create a new record on Table product and here I have a portal where I list all my ingredients. The problems is that the products that I make are just 4 so, I would like to avoid to insert the same ingredients each time to save time. How is possible in a portal make that working?

      Thank you very much for your help

      Cheers

      Andrea

        • 1. Re: Auto enter records in a portal
          philmodjunk

          We "pre-load" our line items portal on our Purchase Order system here as we redeem used beverage containers here and most customers bring pretty much the same type of stuff and this saves our data-entry people a lot of time.

          We use a script similar to this:

          #Starts on PurchaseOrder layout, creates a new PO, then 4 line item records for it.
          Freeze Window
          New/Record Request
          Set Variable [$ID ; PurchaseOrders::PO_ID]
          Go To Layout [LineItems]
          New Record/Request
          Set Field [LineItems::PO_ID ; $ID]
          Set Field [LineItems::Material ; "CRV Al Cans"]
          New Record/Request
          Set Field [LineItems::PO_ID ; $ID]
          Set Field [LineItems::Material ; "CRV #1 PET Plastic"]
          New Record/Request
          Set Field [LineItems::PO_ID ; $ID]
          Set Field [LineItems::Material ; "CRV #2 Plastic"]
          New Record/Request
          Set Field [LineItems::PO_ID ; $ID]
          Set Field [LineItems::Material ; "CRV #Glass"]
          Go To Layout [original Layout]

          Note: this is way simplified from the actual script. In the actual script, I pull up a list of materials from a related table where a field in that table identifies those to be put automatically on every tag and the script loops through them--which makes it much easier to manage changes when the State of California decrees different container categories on us.

          • 2. Re: Auto enter records in a portal
            AndreaPaulaner

            Thank you very much for your help. Looks not so easy for me, but I will try, Thanks

            Cheers

            Andrea