CiviCRM Community Forums (archive)

Regarding inserting, adding or updating information in custom fields from API...

After a whole day (14+ hours) of trying to figure this out, I finally figured out that if I have a custom field that has a name in the database table called orders_2 then I need to just use the _2 part (not the orders part) and add the word custom like this:
$params['custom_2']='data';

I put info in wiki here:
http://wiki.civicrm.org/confluence/display/CRMDOC/Custom+Data+Group+and+Custom+Field+APIs

I hope this saves at least one person a whole day of struggling!!

My issue was, that after all the reading I did, I never picked up on the fact that I should use custom_123 instead of the actual field name in the table like myname_123 ... I assumed (never assume) that whenever I saw custom_ in an example that it was just a placeholder that was saying "put the name of your custom field here" ... of course what it was really saying was "no really, use the word custom_"!!!!