Answers

• allan Posts: 64,301Questions: 1Answers: 10,618 Site admin

  April 18

  Hi Danilo,

  Can you provide a little more information please? For example is this using an Editor form? Can you post a screenshot of what you currently have? I'm not quite managing to picture it at the moment I'm afraid.

  Allan
• danilorago Posts: 26Questions: 8Answers: 0

  April 19

  Actually, yes, I am using the editor.
  I don't have anything ready yet or I'm trying to do it, but let's suppose I have:
  Table: Customer
  Field: Customer ID
  Field: First Name
  Field: Last Name

  Table: Sales
  Field: Sales ID
  Field: Customer ID

  In the form where I have to register a sale, using the Sales table, I would like the dropdown field (select type field) that has the Customer ID to show a combination of the First and Last Name fields

  Have I made myself clearer now?
  Thank you very much in advance...
• allan Posts: 64,301Questions: 1Answers: 10,618 Site admin

  11:22AM

  Yes! Many thanks for the clarification.

  You just need to specify the ->label() method for the Options instance for that field with the two columns you want (assuming you are using the provided PHP, .NET or Node.js libraries?).

  There is an example of this here - specifically in the PHP:

          Field::inst( 'users.manager' )
              ->options( Options::inst()
                  ->table( 'users' )
                  ->value( 'id' )
                  ->label( array('first_name', 'last_name') )
              ),
  

  See the Options->label() documentation for more details.

  Allan