How to set the value via Python APIs for simple CONTACT_LIST column ?

11/10/21
Answered - Pending Review

Hi,

i have the column where the type is CONTACT_LIST (single value only, not multiple values) ...

here is the code snippet:

case_owner_email = "[email protected]"

new_row.cells.append({

'column_id': project_metadata_column_map["Case Owner"],

'value': case_owner_email

})

all my email addresses are correct, and all my owners are registered users in Smartsheet, but sometimes, when i open the sheet, i get correct user (pic + name), but other times i get only email address ...

i need that this is always user ...

so, is there any specific formatting for the value ?

thx & rgrds,

ljk

Answers

  • Hi @lkrobot

    I'm not sure why it will sometimes show as an email and sometimes show as the full contact with the name, however if you're using the API you can standardize this by providing the name for the contact as the displayValue in your API call.

    I hope that helps!

    Genevieve

  • Parker OxfordParker Oxford ✭✭✭✭

    Have the people who don't show up correctly have all their information filled out? I don't think this is an API issue as the email will link to the account so as long as the user has all their information populated on their smartsheet account it will show up in the cells when the email is inserted.


    ( @ me in your replies or I'll lose your response! )

Sign In or Register to comment.