Pull Functionality using a service layer

[AbdulabnanMohammed]

Hi Experts

I have published non spatial table  and generated a token to use it and its looks like this and its publicly shared

Now I want to pull the information from service when searched in the project code with a value available in service and corresponding other 2 fields should be autopopulated when selected or entered

How can i achieve
Service url : https://services8.arcgis.com/opMNag2LPyZVnSsz/ArcGIS/rest/services/KBD_Project_Code_v2/FeatureServer...


Kindly Guide me or correct me with the correction

Highly Appreciate the support @ISM

Attched the xls

[DougBrowning]

My guess is that default values tend to load at the end.  I would try moving the default value in line 2 to the calculation column instead - note you will then probably have to put " " quotes around the URL.  Try that.

[AbdulabnanMohammed]

Thank you for the reply 

I'm just exploring this pull functionality on feature service url as I don’t have much experience on it.

I shall be thankful to you if you can provide the corrected excel 

I was just testing  this scenario to pull the record and based on that record value corresponding fields information should be loaded 

Thank u

[DougBrowning]

Just move it over to calculation column.

[AbdulabnanMohammed]

Thank You so much for the quick response

Receiving below error 

I'm receiving this error once i moved calculation column and also how can i pull other 2 fields(Client name and project name) based on  project code 

Thanks 

[DougBrowning]

You need "" around the URL when moving to calculation.  I attached a sample before.

[AbdulabnanMohammed]

Thank You 

Hi
I have successfully implemented this scenario but with changes to spatial data feature service instead of hosted feature service table with same fields are there in both

But why it doesnt work with non spatial data because i have list from 2017 to till update which i need to design but hosted service table doesnt work

Is this the issue of authentication , I tried with postman also any suggestion please to correct

Attached the working xls designed for spatial data service file
Any Guidance or any sample form 
@DougBrowning 

@IsmaelChivite