Link Field - AutoFill (v2023)

[shahparzsoft]

I have a link field in a Grid Add Form.
When i use resident_id like '90296-13' then AutoFill doesn't work.
but when i use resident_id like '9029613' then Auto Fill Works Fine.

I am using version 2023.13

[arbei]

You may enable Debug and then check HTTP response to see if your value is send to server side correctly. If yes, check HTTP response and see if there is any errors from server side.

[shahparzsoft]

The below is the response when we select '90082-1'
{
"result": "OK",
"records": [],
"totalRecordCount": 0,
"sql": "SELECT DISTINCT resident_id AS lf, resident_name AS af0 FROM residents WHERE 1=0",
"version": "19.13.0"
}

The below is the response when we select '90082_1'

{
"result": "OK",
"records": [
{
"lf": "9",
"af0": "STREET LIGHTS"
}
],
"totalRecordCount": 1,
"sql": "SELECT DISTINCT resident_id AS lf, resident_name AS af0 FROM residents WHERE resident_id IN (9)",
"version": "19.13.0"
}

please advise .....

[arbei]

Check the HTTP Request in the Network panel of your browser, see the Payload and check if the value '90082-1' is sent.