We recently conducted a podcast with a non-profit customer, the Atlanta Two Hundred, who uses TrackVia for its Toys for Tots initiative.
If your zoning field is linked to another database that contains the zoning information you could use our parentlookup() function to retrieve any data from that database and insert it into a field in your other database. For this formula you simply enter the name of the field that links to the database as the first argument and then the field you would like to retrieve from that database as the second. For Example: You might use a formula of parentlookup("Zone","Zone Regulations") to retrieve regulations from the Zones database and enter this into a field in your other.
You can merge any view by clicking on the Mail Merge Link in the Tools Section of the Database Overview Page. You then select the view to merge and the corresponding template to use.
I'll have a member of our technical support team follow-up with you or post a follow-up comment tomorrow if you are still experiencing problems.
Sam -
I'll have a member of our technical support team follow up with a reply tomorrow morning regarding your desire to include a link to parent drop down list in a web form.
Lee-
It is possible to determine the number of digits you would like included after the decimal point.
If you currently have a view that includes your currency field, perform the following:
Please let us know if you have any additional questions. You might also be interested in reading more about our calculated formulas.
With TrackVia you can link fields from two dabases using the link to parent field type.
For example if you have two databases:
1. Sales reps database (called the parent database) with all rep contact information. Assume this databas includes a field called, sales rep.
2. Sales leads database (called the child database) with all leads.
You can link the Sales Rep field name to the sales leads database through a link to parent field type. You will then be presented with a drop down list for all rep names included in your reps databases.
Once you have linked the databases together you have the ability to incorporate any fields included in the parent database in a view created from the child database. When you go to create your view for your sales leads database using our custom views feature you will have the option to include the parent fields in your view. These fields are denoted in brackets: [Sales Rep].
Let me know if this addresses your question.
If you are looking to create a web form in TrackVia. You may want to view our web form demo.
Check out the recent additions to our video training library:
How to send an email campaign
How to find duplicates
How to create a web form
We recently added the following videos to our video training library:
How to create a custom database
How to add users
How to set user permissions
How to enable SSL Encryption
How to restrict access by IP Filtering
We will continue to add new videos to the library. Let us know what training videos you would like us to produce.
We hear this from many of our customers who are looking for a customizable database application. They find TrackVia to be a powerful database that can be customized to meet their data tracking needs.
We have a few case studies on our web site featuring companies across industries who were exploring expensive custom database applications and ended up choosing TrackVia. These companies (NAI 1st Valley, Meridian Resources, and Larry John Wright, Inc. Advertising) have found TrackVia to meet their custom needs.