How do I add a record with a pointer in it.

[Sander Kristel]

When add a record (create service) and I map a value to the pointer field it fails, when I don't the field remains empty?

[Evgene Karachevtsev]

Hello Sander,

Could you please clarify what value do you map on pointer field? It should contain the id of record in related collection. Please look at this link: http://devcenter.appery.io/documentat...

[Sander Kristel]

I have got 2 collections 1 with a pointer to the other. I use create service to add a record to collection A and map the _id to a LocalVariable. I then use the create service to add a record to collection B using the LocalVariable to populate the pointer - this doesnt work.

[Kateryna Grynko]

Hi Sander,

How do you add a record of pointer type?

Did you map a localStorage variable to a parameter of pointer type? If yes then note you would need to add both ID and column name.

For example, if you pass ID via mapping, add the following code to this parameter:
prereturn '{"collName":"myColumn", "_id":"' + value + '"}';/preWhere 'myColumn' is a name of the column where the pointer points.

[Sander Kristel]

Hi Katya not quite sure I get it tbh:

So if I have a collection called "A" and I add a record with an "_id" and then want to add a record to a collection called "B" with a pointerfield called "AID" what would the syntax be please?

[Alena Prykhodko]

This example will help you:

1. Street collection
   http://prntscr.com/3o5ak7
2. Address collection
   http://prntscr.com/3o5aod
3. "Create" Service:
   http://prntscr.com/3o5avo
   http://prntscr.com/3o5b03
   http://prntscr.com/3o5baq

[Sander Kristel]

Great stuff, thanks!

[Sander Kristel]

Hi thanks for that but it works in test but not in the app? I've added the "return '{"collName":"myColumn", "_id":"' + value + '"}';" statement to the EditJS mapping and use an alert to ensure it is using the right parameters. It doesn't add a record at all.

In test it works fine

[Alena Prykhodko]

Did you invoke Service?
How exactly?

[Sander Kristel]

Yes, I invoke the create service to add the record to collection "A" and then on the success event of that service invoke the create service for collection "B"