3 Replies Latest reply on Nov 19, 2014 11:38 AM by philmodjunk

    Turn "Field Entry" selections on and off in a script

    BillPlunkett

      Title

      Turn "Field Entry" selections on and off in a script

      Post

      I have an Expense layout with vendor Name and Address fields filled in from a related vendor table based on the VendorID in the Expense record. 

      I have a button in case they need to add a new vendor.  I have the vendor name and address fields as read only normally but want to make the editable if the new vendor button is clicked.

      How do I do this?

      thanks, Bill

        • 1. Re: Turn "Field Entry" selections on and off in a script
          jbante

          Separate from the question you asked: on your Expense layout, do the vendor name and address fields belong to the Expense table, or the vendor table? It sounds like you have them as fields on the Expense table, but it's typically recommended that those be fields from the Vendor table.

          Now, to address what you actually asked: I would create new global fields for the new vendor name and address, and make the "New Vendor" button a pop-over showing those two fields and a "Create" button. That button would then take the entered information, create the related Vendor record, and connect it with the Expense record. The existing Vendor fields on the Expense layout would remain non-enterable.

          • 2. Re: Turn "Field Entry" selections on and off in a script
            BillPlunkett

            Yes, I thought of that process but it just seemed a little more straight forward for the user to enter the new vendor in the existing name and address fields on the layout.

            And yes the vendor name and address are part of the vendor table - only the vendorID is in the expense_header table.

            thanks

            • 3. Re: Turn "Field Entry" selections on and off in a script
              philmodjunk

              Go to field can put the cursor into a field for which Browse mode access is blocked via a behavior setting in the inspector.

              Editable copies of these fields can be placed inside a popover that you open for this purpose.