Details about this thread
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 322 subscribers
  • Views 2013 views
  • Users 0 members are here

Calculated Field two fields

Craig Mariner

Hi Guys

I want to pre-populate the Name field of a record with the date and another field entry. How can I achieve this please I believe I need to calculate the field but not sure which code to use example:

Name = Date Created + Supervisor Name

Supervisor name is a text field that gets filled in manually.

I need something like: now(), and (supervisor_name_c))

Thank you

Craig

Parents
  • 0

    Hi Craig Mariner 

    The formula maybe something like that:

    concat($date_entered," - ", $supervisor_name_c)

    Follow this article in order to implement this formula into target field.

    Kind regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Hi Andre 

    Thanks for reply however when I try this code I get: concat: All parameters must be of type 'string' any ideas why this is happening please?

    Thanks

    Craig

  • 0 in reply to Craig Mariner

    Sorry!

    You need to convert the $date_entered to string, so the code maybe something like that:

    concat(toString($date_entered)," - ", $supervisor_name_c)

    André Lopes
    Lampada Global
    Skype: andre.lampada
Reply
  • 0 in reply to Craig Mariner

    Sorry!

    You need to convert the $date_entered to string, so the code maybe something like that:

    concat(toString($date_entered)," - ", $supervisor_name_c)

    André Lopes
    Lampada Global
    Skype: andre.lampada
Children
No Data