This article will offer best practices in building a data entry form to create a new or update an existing organization contacts record and associating this record with an organization record. Once created, review Customizing the Organization Dashboard to learn how to link this form to the organization record.
This form could also be used as the New Record link on the Organization Contact Lookup page.
Instructions for this process can be found in the Customizing the New Record Lookup Link article.
Create the Form
Edit the Form Properties
School Key (Parent Key)
A text box mapped to Parent Key is needed to ensure that record is associated with the correct organization. Once a school name is selected in the previous form field, this field auto populates with the CEEB of the organization selected.
Ensure that this field is only mapped once on the form. In addition, if more than one "School Name Search" appears on the form, the two fields need to be separated by a section break.
What is the best practice recommendation for collecting organization contacts addresses?
If the query is built using the organizations contacts query base, it is not necessary to collect the organization contact address on this form. Create a query to return the organization address associated with organization contacts record.
If the organization contact's email address is used as both the email address and the unique for merging field, three fields must exist on the form to store this data correctly and to create a new or match on an existing record upon form submission.
Unique for Merging Field
Add a Text Box form field mapped to the custom email unique for merging field and use a formula. This will copy the value entered in the Device Value form field (eliminating the need to input the email address twice and waiting for the Organization Contact Unique for Merging Rule to run).
Rather than waiting for the display name rule to run to set the display name field, a form field may be added to set the display name field upon submission of the form. Refer to the Managing Organization Contact Display Name Rule article for more information.
Add a text box form field for first name and last name and map appropriately. Add a text box mapped to Record > Name (Display Name). Add the calculation formula of "@sys:field:contact_first + ' ' + @sys:field:contact_last." Under Options, select Read Only or Hidden.