Formula Help - addLinkMultipleId

[esforim]

I'm trying to use this but I can't get it to work correctly.

Where am I going wrong?

Scenario:

Relationship: Case <> Meeting

Field: "DueDate" will have ID of the Meeting

DueDateID= record\create('Meeting', 'name', 'Due Date')

This was my original code, it perfect. It will create a Meeting call Due Date, and it will then get the ID of the meeting and store if in field call DueDate. The problem arise when I want to assign a team to it. I tried various method, two example that I thought it would work but it doesn't below:

DueDateID= record\create('Meeting', 'name', 'Due Date', entity\addLinkMultipleId('teams', 'idhere123') ) // fail
DueDateID= record\create('Meeting', 'name', 'Due Date', teamuserIds, entity\addLinkMultipleId('teams', 'idhere123') ) // fail

// Even tried this way by doing this 'update' afterward.
record\update('Meeting', DueDateID, entity\addLinkMultipleId('teams', 'idhere123'));

Some link for your reference:

https://docs.espocrm.com/administration/formula/entity/#entityaddlinkmultipleid

https://docs.espocrm.com/administration/formula/record/#recordcreate

https://docs.espocrm.com/administration/formula/record/#recordupdate

So... how do we use this? It not problem adding the teams ID to the current entity, but how would I do it for other entity.

[item]

maybe this :

https://docs.espocrm.com/administration/formula/record/#recordrelate

[esforim]

Thanks Boss. I will give rabii method a try first.

[rabii]

I'm trying to use this but I can't get it to work correctly.

Where am I going wrong?

Scenario:

Relationship: Case <> Meeting

Field: "DueDate" will have ID of the Meeting

DueDateID= record\create('Meeting', 'name', 'Due Date')

This was my original code, it perfect. It will create a Meeting call Due Date, and it will then get the ID of the meeting and store if in field call DueDate. The problem arise when I want to assign a team to it. I tried various method, two example that I thought it would work but it doesn't below:

DueDateID= record\create('Meeting', 'name', 'Due Date', entity\addLinkMultipleId('teams', 'idhere123') ) // fail
DueDateID= record\create('Meeting', 'name', 'Due Date', teamuserIds, entity\addLinkMultipleId('teams', 'idhere123') ) // fail

// Even tried this way by doing this 'update' afterward.
record\update('Meeting', DueDateID, entity\addLinkMultipleId('teams', 'idhere123'));

Some link for your reference:

https://docs.espocrm.com/administration/formula/entity/#entityaddlinkmultipleid

https://docs.espocrm.com/administration/formula/record/#recordcreate

https://docs.espocrm.com/administration/formula/record/#recordupdate

So... how do we use this? It not problem adding the teams ID to the current entity, but how would I do it for other entity.

i have just tried it, if i understand do you the teams of the case to be copied to the meeting ? anyway you can always do it this way simply and it works:

DueDateID = record\create('Meeting', 'name', 'Due Date', 'teamsIds', list('650af6a7b43ff6b0a', '650af6b124b387847')); 

If you want to pass the teams from the case entity then you could do it as below:

DueDateID = record\create('Meeting', 'name', 'Due Date', 'teamsIds', teamsIds); 

That should work fine as i have tested it and it works, version 8.0

[esforim]

Love you. I have feeling it will work! Will give it a try over the weekend.

I didn't know this 'list('id') exist.

[esforim]

Update, working perfect.

[esforim]

rabii Would you know how to use the "DateEnd" and Duration in the records?

Currently all record is create Start and End time to be the same, I tried "duration" but it doesn't seem to do anything. I then try to do a few of these stupid method:

record\update('Meeting', dueDateID, 'dateEnd', datetime\addMinutes(record\attribute('Meeting', dueDateID, dateStart), '90')); // update by finding the ID and adding time to it.

record\create('Meeting', 'duration', '90') // this change the Duration field but it doesn't actual change the time.

record\create('Meeting', 'dateEnd', datetime\addMinutes(dateStart, '90') // I think this doesn't work because Formula don't know what what the dateStart is, as that is a field in Meeting only.

record\create('Meeting', 'dateEnd', datetime\addMinutes(dueDate, '90') // I think this don't work because dueDate is a date only field and it not dateTime field.

[esforim]

rabii Would you know how to use the "DateEnd" and Duration in the records?

Thank guys! Manage to solve it by using Sandbox and trial and error, I did my formula incorrect with the record update, here is the solution if anyone need it:

record\update('Meeting', dueDateID, 'dateEnd', datetime\addMinutes(record\attribute('Meeting', dueDateID, 'dateStart'), 120))

// formula 'step' for beginner reading
// update a Record
// For Meeting entity
// get the ID number in a field call dueDateID
// the field I want to update is "dateEnd" in my Meeting
// I want to add Minutes to my record
// I want to calculate it from the dateStart, but I need to get that data from my Meeting using the record\attribute function
// I want to add 120 minutes as the end time.

[rabii]

hey

you should use it like below avoid using number as string '120' it should be number 120 instead

record\update('Meeting', dueDateID, 'dateEnd', datetime\addMinutes(record\attribute('Meeting', dueDateID, 'dateStart'), 120))
​ 

[esforim]

Thanks rabii, for some reason it still work as a string (or I could be majorly wrong here) but I will fix it.