DavidCushworth

Automatically Entering a Record from a Script.

Discussion created by DavidCushworth on Nov 7, 2016
Latest reply on Nov 7, 2016 by DavidCushworth

I have a database of contacts (Name of the DB is "Sponsors"), usual stuff:  Record ID & personal details as nauseam.

 

I have a database (name of the DB is "Sponsors Log") that records what communications we have with each contact.  Three fields:  Record ID of the contact , Date, Comments.

 

The comments are viewed in a Portal on the customer Layout.

 

I have them in a relationship connected between the Record ID's in each database.    I have permissions set to allow the Sponsors Log DB to be changed from within the portal.

 

I then have a pre-defined e-mail we send to the contacts, using a script.     Part of the script is meant to make an entry into the Comments DB showing the date & description of the email sent.

 

I Screen Shot 2016-11-07 at 4.02.47 PM.png

The record is created successfully, the data for the date & Comments is there, but for some reason the Record ID is not being recorded.  I get 2 out 3, with the most important one being omitted.

 

In the Sponsors Log DB, the field I use for the Record ID (actual Name Sponsor ID) is just an indexed Number.    I have tried it with a calculated value but nothing seems to work.

 

It should be an extremely simple thing, but for reason I can't get it to work.

 

Help !!

 

Thanks

Outcomes