Organization Contact New Record Form
- 08 Nov 2023
- 3 minute read
- Print
- DarkLight
- PDF
Organization Contact New Record Form
- Updated 08 Nov 2023
- 3 minute read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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 and Configure a New Record Data Entry Form
Create the Form
Select Forms on the top navigation bar
Select New Form.
Select Insert. A popup appears (pictured).
Configure each setting* as necessary.
Click Save
*Click here for a complete listing of all setting descriptions.
Edit the Form Properties
Select Edit Form.
Select Edit Properties.
Change the Scope of the form to Dataset
Select the Dataset Organization Contacts.
Click Save.
Remove all of the default form fields from the form.
Add in any form fields desired when creating a new dataset record, mapping to the organization contacts dataset-scoped fields.
*Click here for a complete listing of all setting descriptions.
.png?sv=2022-11-02&spr=https&st=2024-10-12T09%3A28%3A37Z&se=2024-10-12T09%3A38%3A37Z&sr=c&sp=r&sig=xt0rCxg5efkP%2BwUZBYA08KT9yzTEC7hgrvW3feiH1cc%3D)
Required Form Fields
Confirm that the following form fields have been added to the form to ensure the record is created and data is save to the record properly:
Parent Record Data
To associate the organization contact record with the parent organization record, add the following form fields to the new record creation form:
School Name
Field Type - Text Box
System Field - Unmapped
Autosuggest - School Name Search
Options - Required
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.
Field Type - Text Box
System Field - Record - Parent Key
Autosuggest - School Key
Options - Hidden
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.
Email Address and Unique for Merging
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.
Device Type
Field Type - Select List
System Field - Device - Device Type
Default Value - Email
Options - Hidden
Device Value
Field Type - Text Box
System Field - Device - Device - Value
Options - Required
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).
Field Type - Text Box
System Field - Fields - Details - Email
Calculation Formula - @sys:device:value
.png?sv=2022-11-02&spr=https&st=2024-10-12T09%3A28%3A37Z&se=2024-10-12T09%3A38%3A37Z&sr=c&sp=r&sig=xt0rCxg5efkP%2BwUZBYA08KT9yzTEC7hgrvW3feiH1cc%3D "image(48).png")
Display Name
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.
Field Type - Text Box
System Field - Record - Name (Display Name)
Calculation Formula - @sys:field:contact_first + ' ' + @sys:field:contact_last
Note that in this syntax, ' ' is two single quotes separated by a space, not double-quotes.
Was this article helpful?
