Calculated Fields (Formula) Select first name

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • roman042
    Member
    • Jun 2017
    • 64

    Calculated Fields (Formula) Select first name

    Здравствуйте, разбираюсь в построении формул.
    Хочу присвоить в поле varchar например первую группу из списка групп
    Как то так: name = teamsNames[0]

    Тип поля из которого получаю значение Link Multiple
    Last edited by roman042; 06-02-2017, 10:10 AM.
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hello
    In English, please
    any linkMultiple Name field is an object - teamsIds:["52bd3ee937361"], teamsNames:{52bd3ee937361: "Sales Department"}

    Comment

    • roman042
      Member
      • Jun 2017
      • 64

      #3
      But how to get the value of this object and send it to another field ?
      name = teamsNames["0"] or how ?

      For example, get the first object in order?
      Last edited by roman042; 06-02-2017, 10:28 AM.

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        As you can see, the properties of this object are the values from teamsIds field. Get first one from ids list and get the value from names object. But linkMultiple could be not loaded for some reason everytime

        Comment

        • roman042
          Member
          • Jun 2017
          • 64

          #5
          Ok, then how do I get the teamsIds first value in a string?

          Comment

          Working...