How can I control the collection Id field.

Ask the community
,
1

When I insert a new row the Id is filed is automatically populated with a string like “52cb3376-528a-48fd-9e36-e612f075b1a0”.
In the examples I have seen that data can be accessed using the ID '00001" for example. So I assume I can populate the Id with a numeric fields that I can increment manually.
How can I control the Id field when inserting anew row in the collection?

2

Can only be done with Code
set the value of _id Before saving/inserting the data. This parameter can NOT be changed after it is inserted

3

Thanks, I did it, but it created a new field named ID. Maybe I used ID instead of _ID. Could it be the reason?

4

Thanks, it works perfectly. I can now control the Id field.