Hello. I’ve created updatable BAQs in the past and been able to use them in a mobile (EWA) dashboard.
I am attempting to find a way for the sales reps to log visit notes for their customers. Reusing the CRMCall table seems like a great way to go. Unfortunately, there are some required fields (RelatedToFile [always ‘person’], Key1 [CustNum], and Key3). I’ve figured out how to get RelatedToFile to default to ‘person’, and Key3 can be blank.
What I’m left with is setting the value of Key1 to default to the Customer.CustNum. This column is already in the BAQ so I would think it would be easy to do but can’t seem to figure out the syntax to do so.
Any suggestions would be greatly appreciated. Thank you for your time in advance. I have attached a screenshot in case it can be of use to you.