Forum Discussion

JoshuaDavis1's avatar
JoshuaDavis1
Qrew Trainee
2 months ago

Consolidate Field Types

Hello,  Is it possible to consolidate several Text - Multiple Choice field types into 1 field for a report? I believe I would have to create a new field and a text-formula as well. My working theory...
formulas
  • DonLarson's avatar
    DonLarson
    2 months ago

    Joshua,

    You said that you needed to pull data of the manufacturer and the scope.   Your formula or the List function that MarkShnier__You  posted can string together the names of the manufacturers.   To get a lot of information I suggest you build the app a little different.

     A Table of manufacturers gives you one source of truth.  You do not have to have Dell in four separate list and maintain them.   You also can keep adding info about the manufacturer and expanding what the Bids know through the relationship.

    The formula you posted does not have any conditionals in it.  Are you looking to evaluate who the manufacture is to show something?  For example:  

    If ( [Related Scope One Name]="Dell", "A value for the report",  "A different value for the report) 

     

DonLarson's avatar
DonLarson
Qrew Elite
26 days ago

Joshua,

If you just want to string together the names of the manufacturers, then Mark's solution would give you a column of names.

A list of the names can be done like this:

[Manufacturer 1] & " " & [Manufacturer 2]

This will give you a row with a space between the names.