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