Please help, I created a Skuid page and finally got it to work just as I wanted. But when I added it as component on my record page it is not pulling the correct data. I am looking up Contacts on Account, that are tied to a junction object called AccountRoles.
I have 4 models: Account, AccountRole, CustomObject, SelectedAccountRole and Contact. On Load, the page retrieves the Account ID and all related AccountRoles
The scenerio is this.
I have a Related Contact UI picklist of all of the contacts related to the Account. This field is looking at all AccountRole ids that are tied to the Account.
Once the user selects a Related Contact the AccountRole ID is saved to a Salesforce Field called AccountRoleID.
A model condition of the SelectedAccountRole retrieves the matching AccountRole
A model condition on the Contact retrieves the matching Contact.
Everything is working as expected when I run it in Skuid preview. But it is not working on the Salesforce page. On the Salesforce page, after the user selects the Related Contact, the selected AccountRole is blank, and because of this it is pulling the first contact record in Salesforce that is totally unrelated to this Account.
Here is how it is appearing in Skuid - which is what I want.
On the Salesforce page SelectedEntiyRole is blank, and the Contact is a random record.
Thanks in advance for your help.