Basic questions regarding tables and fields in AC

[#1]

Hi,

Can you explain what the following icons represent in AC?

1. What does the yellow cogwheel represent inside the field icon?

2. What does the red exclamation mark "!" mean inside the field icon?

3. What does the white blank sqaure mean?

Thanks.

[#2 · Accepted solution]

Hi Jae,

Sure:

• the yellow wheel indicates that the field is a calculated field (populated by transforming/calculating data from other fields)
• the red "!" means that the field is mandatory, can't be a null value
• the square icon indicates that this is a container, i.e. a group of fields, usually used for addresses

Florent