Skip to main content
Question

List formula to include field names

  • January 19, 2021
  • 0 replies
  • 22 views
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
------------------------------

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/
------------------------------
Terms & ConditionsAccessibility statement