field_expression - kolom atau ekspresi. Semua field_expressions harus memiliki jenis yang sama.
Contoh
Misalkan Anda melacak beberapa pembalap pada beberapa babak dalam sebuah kompetisi. Pembalap mungkin tidak ikut babak eliminasi karena berbagai alasan. Anda ingin membuat kolom First_Time yang berisi perolehan pertama setiap pembalap.
Berikut data balapan tersebut.
Pembalap
Heat1
Heat2
Heat3
Pembalap X
38,22
37,61
Pembalap Y
41,33
38,04
Pembalap Z
39,27
39,04
38,85
Gunakan formula berikut di kolom First_Time untuk mendapatkan nilai non-null pertama dari kolom Babak:
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-07-31 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:"]]
