Long Text Area フィールドを数式で使う

Answersで回答する時に使う情報のまとめに戻る

この回答ではISBLANKが使えたと言っているけど、本当かな？

• Need Formula to Check if All 4 Long Text Area Fields are Filled Out

Long Text Area(32768)

ISBLANK	(Long_text__c)

Error: You referenced an unsupported field type called "Long Text Area" using the following field: Long_text__c

LEN(Long_text__c) > 0

Error: You referenced an unsupported field type called "Long Text Area" using the following field: Long_text__c

Long Text Area(500)

ISBLANK	(Long_text__c)

Error: You referenced an unsupported field type called "Long Text Area" using the following field: Long_text__c

LEN(Long_text__c) > 0

Error: You referenced an unsupported field type called "Long Text Area" using the following field: Long_text__c

Text Area(255)

問題ない

Rich Text Area(256)

ISBLANK	(Long_text__c)

Error: You referenced an unsupported field type called "Rich Text Area" using the following field: Long_text__c

LEN(Long_text__c) > 0

Error: You referenced an unsupported field type called "Rich Text Area" using the following field: Long_text__c

REGEX

REGEXは使えるようです

• ロングテキスト項目の改行を制御する方法はありますか？

入力規則を使う場合は以下で対応できるとは思います。

AND(
REGEX(<field name>, '(.*\r?\n.*)*'),
NOT(ISBLANK(<field name>))
)