How to pull the latest record from a view layer field using pulldata("@layer") in Survey123 (based on staff name)

hmorgan

Hi everyone,

I’m working on a Survey123 Connect project that involves two linked view layers created from one main feature layer.

• Main feature layer: Best_Staff_Management_Collation

• HR view layer: used by the HR team to enter staff performance data each quarter.

  • Important field: Percentage_Score

• GM view layer: used by the GM team to enter their own data each quarter for each staff.

  • In this form, I want to automatically pull the latest Percentage_Score from the HR view layer for that staff.

Each HR record includes:

• Name — staff name

• Percentage_Score — quarterly performance result

• CreationDate — (system field that captures when the record was created)

 

This is my expression, but it is not pulling the lastest record for quarter 3 : pulldata("@layer","getValue","attributes.Percentage_Score","https://services1.arcgis.com/m9p5y180BqMf6JT7/arcgis/rest/services/Best_Staff_Management_Collation_3_view/FeatureServer/0", concat("Name='", ${Name},"'"))

dougbrowning

looks like a typo here  concept("