https://community.esri.com/t5/arcgis-survey123-questions/getrecord-troubleshooting/m-p/1289076#M49235 <P>Barbara,</P><P>THANK YOU A BILLION. This worked! Wonderful!</P><P>Brooke</P> Mon, 15 May 2023 11:36:12 GMT bsklaohfl 2023-05-15T11:36:12Z https://community.esri.com/t5/arcgis-survey123-questions/getrecord-troubleshooting/m-p/1288610#M49217 <P>Hi everyone,</P><P>&nbsp;</P><P>I have been having issues getting my JSON to populate with the last record. Basically, once the user selects Station_Name, I would like the previous record to pull up. Could someone please review my XLS? Thank you!</P> Fri, 12 May 2023 15:12:57 GMT https://community.esri.com/t5/arcgis-survey123-questions/getrecord-troubleshooting/m-p/1288610#M49217 bsklaohfl 2023-05-12T15:12:57Z https://community.esri.com/t5/arcgis-survey123-questions/getrecord-troubleshooting/m-p/1288840#M49225 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/660570">@bsklaohfl</a>,<BR /><BR />It looks like the problem is in the where clause. Try changing<BR /><BR /><EM>concat("Station Name=",${Station_Name},"'")</EM><BR /><BR />to<BR /><BR /><EM>concat("Station_Name='",${Station_Name},"'")<BR /></EM><BR /><BR />The field name has an underscore in the feature layer, and there also needs to be a single quote before the double quote so the value for ${Station_Name} will be wrapped in single quotes.<BR /><BR />Thanks,<BR />-Barbara</P> Sat, 13 May 2023 00:22:04 GMT https://community.esri.com/t5/arcgis-survey123-questions/getrecord-troubleshooting/m-p/1288840#M49225 BarbaraWebster1 2023-05-13T00:22:04Z https://community.esri.com/t5/arcgis-survey123-questions/getrecord-troubleshooting/m-p/1289076#M49235 <P>Barbara,</P><P>THANK YOU A BILLION. This worked! Wonderful!</P><P>Brooke</P> Mon, 15 May 2023 11:36:12 GMT https://community.esri.com/t5/arcgis-survey123-questions/getrecord-troubleshooting/m-p/1289076#M49235 bsklaohfl 2023-05-15T11:36:12Z