editable grid missing ids

Data type

Hi there,

It looks like you are trying to save the value in fv!item.travelMode.display, because of which the fv!item.travelMode.id is not getting updated. But when I tried the same implementation on my Appian environment, the component is saving the primary key of the record selected, unlike your case where the label is getting saved. 

Can you please add a screenshot of the 'Travel Mode' record for me to see if you have a primary key there?

Hi there,

It looks like you are trying to save the value in fv!item.travelMode.display, because of which the fv!item.travelMode.id is not getting updated. But when I tried the same implementation on my Appian environment, the component is saving the primary key of the record selected, unlike your case where the label is getting saved. 

Can you please add a screenshot of the 'Travel Mode' record for me to see if you have a primary key there?

The Id column is set to text. Are the values in 'id' and 'display' columns the same? 

Thank you for helping me.

Both are text should I changed id to int because of pk?

Here is adata preview on record type

Ah. There is the issue. Because your Id column has text values that is why you are not getting the Ids while trying to save. Please change the source of id column in your record to point to the ID column of your data store entity. And then try to re-run the component. You should have the correct results. 

You will also have to change the saveInto variable from fv!item.travelMode.display to fv!item.travelMode.id so that ids can be saved in the dedicated column. 

I think that I broke every thing what I have done. I had to refactoring database, CDT and record type, but now is not even working

Yeah unfortunately this is fairly extensive change - what error are you having now?

Hi Peter I had to refactor database and changed primary key from text to integer.

Now it seem that also does not populate rest of the values from CDT except primary key. I am new at Appian and maybe I do something wrong.

Please could you give me some advice. 

Thank you.

Record type

Hi robert,
on the first qucik check,
in your pickerfield you are just adressing travelmode.id which means you are just saving a value into theID fied.
so you have to change or adjust your saveInto accordingly.
First shot should be: try to store without the ".id in your saveinto and (your value parameter as well without ".id")


perhaps this article can support you
Record Picker Component - Appian 21.4

If I set saveinto without id I get an exception

did you try to change "value" as well into "without .id"?