Customer wants to show a Custom Field (with a formula) on the Invoice Record, showing a value from the Subcustomer record and from the Project record. The invoice was created from the Project.
This can be done by creating a Saved Search, a custom body field, and a workflow.
1. Edit the Contact Field first since this will be used for the Saved Search and it can only be used if the Store Value is checked
1. Navigate to Customization > Lists, Records, & Fields > Entity Field
2. Click Contact field
3. Set the following:
○ Label : Contact
○ Type : Free-Form Text
○ Store Value : is checked
○ Applies to : Job
4. Click Save
2. Create a Workflow to set the Custom Field - Contact
1. Navigate to Customization > Workflow > Workflows > New
2. Basic Information:
○ Name: Enter Job invoice
○ Record Type: Select Job
○ Execute As Admin: Enter Checkmark
○ Release Status: Select Released
○ Initiation: Select Event Based
○ Event Definition:
○ On Create: Enter Checkmark
○ On View or Update: Enter Checkmark
3. Click Save
4. Click State 1
5. Bottom right corner: Click New Action
6. Click Set Field Value
7. Basic Information:
○ Trigger On: Select Entry
8. Parameters:
○ Field: Select Contact
○ Formula: Enter Checkmark
○ Formula: Enter case when {parent} is not null then {parent.companyname}else null end
9. Click Save
3. Create a Saved Search
1. Navigate to Lists > Search > Saved Searches > New
2. Click on Transaction
3. Click on Criteria tab
• Select Type : Invoice
4. Click on Results tab
• Select Job (Main Line) : Contact (Custom)
§ Summary Type : Maximum
• Sort By : Job (Main Line) : Contact (Custom)
5. Click on Available Filters
• Select Internal ID
6. Click Save and Run
4. Create a Custom Body Field to be applied on the Invoice
1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Field > New
2. Set the following setup on the screenshot below
This should show the value on the Invoice record.
Let us know if this works on your end or if you have a different workaround on this ?