After querying a record, I am trying to access a value from a related record, but the value is not showing up. It just returns null. I checked my Record Lists to confirm the expected values are there.
Ex. Record one called Activity Status has a many to one relationship with record two called Activity.
Record Activity Status has the status of the activity for each user with a foreign key called ActivityID that references the Activity record.
Record Activity has the name of the activity.
Ex row for Activity Status: id 1, activityID 2.
Ex row for Activity: id 2, name: "running"
My record query returns the ActivityStatus with id 1 and activityID 2, which is stored in local!data.
I am trying to get the activity name with local!data[recordType!ActivityStatus.relationships.Activity.fields.name]
Does anyone know why this does not work?
Discussion posts and replies are publicly visible
Hi Maria, Did you able to figure out why it doesn't work? Am having same question.
Did you follow the suggestions in this thread? Can you share the code of your query?
Please try ericm's solution.
Otherwise, another possibility is that the Record Security is preventing you from seeing the field.