1 Reply Latest reply on Sep 20, 2013 1:39 AM by GuyStevens

    Permanent Fields on Client



      Permanent Fields on Client


           I have a hosted database with a handful of users. I want a few fields that have e-mail settings (e.g. smtp server) that are specific to the client machine. However, each client may have different settings.

           How do I set up the fields so that each client will store the data in the field, but will not erase when closed. This so the fields can be used in calculations and scripting, etc... that get entered in the items in the send mail script function, including the server, etc... that again, are unique to each client?


        • 1. Re: Permanent Fields on Client

               Does every client use a different login?

               You could create a table with one record for every Account Name and then you create additional fields for any setting you would like to link to this account.

               Smpt settings, email address, ...

               Kind of like a settings table.

               Then when you run a script to send an email you could have a temp field where you set the current account name and that field is related to your "settings" table and there you can get the correct smtp info for that account.

               Damn, I'm clever :p