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...
Forum Discussion
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/
------------------------------
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/
------------------------------