Field Type Comparison Table

Type	Code	Description	Allow API create	Allow API query	Supported filter operators
Text	2	Text	✓	✓	eq, ne, contains, concurrent, notcontains, startswith, notstartswith, endswith, notendswith, isempty, isnotempty
PhoneNumber	3	Mobile phone	-	✓	Same as Text
LandlinePhone	4	Landline	-	✓	Same as Text
Email	5	Email	-	✓	Same as Text
Number	6	Number	✓	✓	eq, ne, gt, lt, ge, le, between, notbetween, isempty, isnotempty
Certificate	7	Identity document	-	✓	Same as Text
Currency	8	Amount	-	✓	Same as Number
SingleSelect	9	Single select	✓	✓	eq, ne, in, notin, isempty, isnotempty
MultipleSelect	10	Multi select	✓	✓	eq, ne, in, notin, concurrent, isempty, isnotempty
Dropdown	11	Dropdown	-	✓	eq, ne, in, notin, isempty, isnotempty
Attachment	14	Attachment	✓	✓	isempty, isnotempty
Date	15	Date	✓	✓	between, notbetween
DateTime	16	Time	✓	✓	between, notbetween
Region	19/23/24	Region	-	✓	eq, ne, between, notbetween, in, isempty, isnotempty
DynamicLink	21	Free link	-	✓	isempty, isnotempty
Divider	22	Section	-	-	-
AmountInWords	25	Amount in words	-	✓	Same as Number
Collaborator	26	Member	✓	✓	eq, ne, in, notin, concurrent, isempty, isnotempty
Department	27	Department	-	✓	eq, ne, between, notbetween, in, notin, concurrent, isempty, isnotempty
Rating	28	Level	-	✓	Same as Number
Relation	29	Related record	✓	✓	eq, ne, in, notin, concurrent, isempty, isnotempty
Lookup	30	Field from another table	-	✓	-
Formula	31	Formula	-	✓	Same as Number
Concatenate	32	Text concatenation	-	✓	Same as Text
AutoNumber	33	Auto number	-	✓	Same as Text
SubTable	34	Subtable	-	✓	isempty, isnotempty
CascadingSelect	35	Cascading select	-	✓	eq, ne, between, notbetween, isempty, isnotempty
Checkbox	36	Checkbox	-	✓	isempty, isnotempty
Rollup	37	Summary	-	✓	Same as Number
DateFormula	38	Formula (date)	-	✓	-
CodeScan	39	Scan code	-	✓	-
Location	40	Location	-	✓	isempty, isnotempty
RichText	41	Rich text	-	✓	isempty, isnotempty
Signature	42	Signature	-	✓	isempty, isnotempty
OCR	43	OCR	-	✓	-
Role	44	Role	-	✓	-
Embed	45	Embed	-	-	-
Time	46	Time	✓	✓	between, notbetween
Barcode	47	Barcode	-	✓	-
OrgRole	48	Organization role	-	✓	eq, ne, in, notin, concurrent, isempty, isnotempty
Button	49	API query (button)	-	-	-
APIQuery	50	API query (dropdown)	-	-	-
QueryRecord	51	Query records	-	-	-
Section	52	Tab	-	-	-
FunctionFormula	53	Function formula	-	✓	-
CustomField	54	Custom field	-	-	-
Array	10000003	Array (workflow)	-	-	-
Object	10000006	Object (workflow)	-	-	-
SimpleArray	10000007	Array (workflow)	-	-	-
ObjectArray	10000008	Object array (workflow)	-	-	-