Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have a model driven apps dataverse table in SMART Audit Customer with columns, art _ AccountManager ( lookup column to SMART Audit Auditors table

I have a model driven apps dataverse table in SMART Audit Customer with columns,
art_AccountManager (lookup column to SMART Audit Auditors table)
art_Rep (lookup column to SMART Audit Auditors table )
OwnerId (owner datatype column system required column)
art_Customer (lookup -looking to Customers V3table).
Write JavaScript to change ownership and define Account Manager and Rep based on related D365 customer. If D365 Customer is not assigned, make Account manager = Owner.
If assigned,
Account manager - Customers V3- EMPLOYEERESPONSIBLENUMBER
Sales Rep - 'Customer postal addresses' - GROSALESREPGPOPERSONNELNUMBER
Use address where Primary = true
Record ownership:
First use Account Manager, else Sales Rep
In JS, check for nulls for Account manager and rep. If both are null, can't reassign the record.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Building Database Driven Catalogs

Authors: Sherif Danish

1st Edition

0070153078, 978-0070153073

More Books

Students also viewed these Databases questions