Hi,
Please can any one help me regarding missing id-s.
I am using editable grid and after select a value from component pickerFieldRecords the id is not saved into local variable. What I am doing wrong?
Here is a code:
Thank you.
Local variable
Discussion posts and replies are publicly visible
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?
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.
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 youRecord 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"?
The same issue
Do you actually need the fields on your interface other than the ID? When you write to the database, as long as the ID is included the reference will be inserted correctly.