Stay organized with collectionsSave and categorize content based on your preferences.
COALESCE
UseCOALESCEto replace null values with a more meaningful default value.
Sample usage
COALESCE(Field1, Field2, Field3)
Syntax
COALESCE(field_expression[,field_expression,...])
Parameters
field_expression- a field or expression. Allfield_expressionsmust be of the same type.
Example
Suppose you are tracking multiple racers across multiple heats in a competition. Racers might sit out heats for various reasons. You want to create aFirst_Timefield that contains each racer's first results.
Here's the race data.
Racer
Heat1
Heat2
Heat3
Racer X
38.22
37.61
Racer Y
41.33
38.04
Racer Z
39.27
39.04
38.85
Use the following formula in theFirst_Timefield to get the first non-null value from theHeatcolumns:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-22 UTC."],[],[],null,["COALESCE\n========\n\nUse `COALESCE` to replace null values with a more meaningful default value.\n\nSample usage\n------------\n\n```\nCOALESCE(Field1, Field2, Field3)\n```\n\nSyntax\n------\n\n```\nCOALESCE( field_expression [, field_expression,...])\n```\n\n### Parameters\n\n- \u003cvar translate=\"no\"\u003efield_expression\u003c/var\u003e - a field or expression. All \u003cvar translate=\"no\"\u003efield_expressions\u003c/var\u003e must be of the same type.\n\nExample\n-------\n\nSuppose you are tracking multiple racers across multiple heats in a competition. Racers might sit out heats for various reasons. You want to create a **First_Time** field that contains each racer's first results.\n\nHere's the race data.\n\nUse the following formula in the **First_Time** field to get the first non-null value from the **Heat** columns: \n\n```\nCOALESCE(Heat1, Heat2, Heat3)\n```\n\nResults:"]]
