Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
5 years ago

List formula to include field names

Is there an easier way to include field names when using the List formula? The method I am using below is two part so wondering if there was an easier way to go about this since I have about 10 fields, FieldA, FieldB, FieldC etc.

1. Create new Formula Text fields for each field as follows
If( IsNull([FieldA])=false, "FieldA " &  [FieldA], "")

2. Create a List formula using the Formula Text fields instead of the original fields FieldA, FieldB, etc.

------------------------------
Ruby Kapil
rubykapil@wi-finity.com
Wi-Finity, Inc
------------------------------
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Maybe sorta, but not really, though you may want to consider a different approach, just to make it a bit easier to manage...

    For each field, setup a variable like this:

    var text fa = IF([field a]="","","Field A " & [field a]);                               This allows you to copy/paste the var and just change out a few items

    Then, for your list formula, you would just have this:

    List("; ",$fa,$fb,$fc...)

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------