# How to configure Column Data Source

Select a column (click on its header). Go to "Data" section of column properties at the right sidebar and click on link "edit".

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2F8ua1V0DYqyIFJMxa7kcE%2Ffile.excalidraw.svg?alt=media&#x26;token=64a9241b-16be-40a2-baef-6d54c25f25bf" alt="" class="gitbook-drawing">

Column Data Source config dialog popup will open. Select "Data Source Type":

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2F6DuevvinGhyqZ0zyf75l%2Ffile.excalidraw.svg?alt=media&#x26;token=2767d636-e86e-4995-a6b9-e76723febf29" alt="" class="gitbook-drawing">

### SObject Data Source

"SObject" Data Source is preselected:

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2F8Rhz5j9ewkq2HPt27W2K%2Ffile.excalidraw.svg?alt=media&#x26;token=59670aab-8d0a-4417-853f-94a989ea60dd" alt="" class="gitbook-drawing">

Select Data Source. When you select data source additional fields will be displayed:

* **"Order"** picklist contains fields of chosen data source object. This option helps you to sort cards in column.
* Check **"Ignore Permissions"** checkbox to show all cards in column (in spite of user's account permissions).
* **"Page Size"** is number of cards shown in a column by default and additionally loaded per each scroll (one page).
* **"Preload Pages"** is number of pages that are loaded by system automatically one by one. Loading progress will be indicated with a spinner around the badge showing number of cards:

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FMiKCdeSpun7CKVIHsGRv%2Ffile.excalidraw.svg?alt=media&#x26;token=16558ced-2a34-4a28-a037-703ef819c7fe" alt="" class="gitbook-drawing">

{% hint style="success" %}
reload several pages with small number of cards per each can save server resources (Salesforce limits) and can be useful when internet connection is slow.
{% endhint %}

When you select data source additional tabs will be displayed:

* Conditions&#x20;
* Related Objects
* Push Topics

### Conditions

To configure condition for current column click "Add Condition". Row with new condition form will be shown. Click <img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FRmGufsmtovDsn10do4jt%2Fimage.png?alt=media&#x26;token=8ba72f99-f124-40ee-95ab-415dfbeba45a" alt="" data-size="line"> button:

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FWwr8UAR5IX3vsjSKVrYP%2Ffile.excalidraw.svg?alt=media&#x26;token=3f54c08f-e7c6-4a22-b52a-c6fcc713f0cc" alt="" class="gitbook-drawing">

Click <img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FMx8GEAKyKvzOTvsdlYBR%2Fimage.png?alt=media&#x26;token=96ba8c9f-8930-485c-a6bf-5c692f70e42c" alt="" data-size="line"> icon to open "Select Field" dialog popup. Choose field and click "Apply":

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FdYmYhDX6ZrYuaPFFiIOz%2Ffile.excalidraw.svg?alt=media&#x26;token=c6688602-e70a-4069-9b6b-eaf9f30057b3" alt="" class="gitbook-drawing">

After it you can select "Operator", "Type" and "Value" for condition. To copy, paste and apply conditions JSON click the proper button (for one condition, for all conditions).

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2F1YCFUPZUQjVKVdPil2K5%2Ffile.excalidraw.svg?alt=media&#x26;token=e745f0ca-e11e-4e02-ba16-12504ff98168" alt="" class="gitbook-drawing">

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FbZcLQcty2drtpCPvEhDD%2Ffile.excalidraw.svg?alt=media&#x26;token=d7967df4-b920-4fde-9654-a406181992a5" alt="" class="gitbook-drawing">

Configure "Logic" if needed:

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FfmmIPEpePMCMP4QpO6Hm%2Ffile.excalidraw.svg?alt=media&#x26;token=536d0e62-1165-404d-b7ae-e506d1160c7a" alt="" class="gitbook-drawing">

{% hint style="success" %}
Logic "All conditions combined with AND operators" will be applied by default if not configured.
{% endhint %}

### Related Objects

Configure [Related Objects](https://docs.flexikanban.ai/standard-kanban/configure-column/how-to-work-with-related-objects) if necessary:

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FDjE5heQuZuat3gGSGhcE%2Ffile.excalidraw.svg?alt=media&#x26;token=202e13dc-1cbd-4f00-943b-d5a190228d38" alt="" class="gitbook-drawing">

### Apex Class Data Source

In some cases Apex Class should be required - e.g., when records from several objects need to be shown.

* Select "Apex Class" as Data source type
* Find necessary Apex Class in the proper lookup. Note, that your organization should have necessary Apex Classes deployed
* Set parameters for this class in JSON format

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2F3536lD2KtNvdm5bC3Q43%2Ffile.excalidraw.svg?alt=media&#x26;token=894f248c-2de0-476b-9996-ff64ada35a6b" alt="" class="gitbook-drawing">

### Push Topics

{% hint style="info" %}
Push Topics allow system generate special push notifications when some fields in some object records are created and/or updated.

Push Topics are created globally, so, they can be subscribed by any other columns in any dashboard.

Push technology, also called the publish/subscribe model, transfers information that is initiated from a server to the client. It will help you to follow the changes in this column.
{% endhint %}

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FPBD7pFmHVdJwH7nATL0p%2Ffile.excalidraw.svg?alt=media&#x26;token=5d4181dc-a43a-4990-b859-92e54d7fd709" alt="" class="gitbook-drawing">

**To create a Push topic** click "Create Push Topic" button and set Name, Query and necessary notifications:

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2F5Z5GkbaHL6BTdX27QGIB%2Ffile.excalidraw.svg?alt=media&#x26;token=759111d0-c591-4c38-ae49-a8c49e9093ce" alt="" class="gitbook-drawing">

* Query should be written in SOQL syntax. List fields which changes you want to subscribe to.
* Check proper checkboxes to push notifications on records creation and/or update.

**To subscribe to existing Push topic** click "Subscribe on Push Topic" button.

<img src="https://3097383375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK2dgObBO5ydOH2ZXDJLa%2Fuploads%2FFeoe94pOvanwEBSaw1cL%2Ffile.excalidraw.svg?alt=media&#x26;token=1555697e-4f8c-4ea7-a0e5-f460bcc71401" alt="" class="gitbook-drawing">

* Select Push Topic in lookup.
* Select "Source ID Field" from the  Push Topic source object, that represents the column source object record ID,
* choose  period "How to handle events",
* select behavior of "Card compact layout" and "Card Layout".

{% hint style="info" %}
Behavior of **Card Layout** can be:

* Hide - if any card layout has been opened, it will be closed
* Refresh - if any card layout has been opened, it will be refreshed
* Not selected - nothing will happen.
  {% endhint %}

{% hint style="warning" %}
Currently behavior of **Card Compact Layout** can be "Refresh" only.
{% endhint %}

As soon as a Push Topic is configured, the system starts evaluating record creates, updates, deletes, and undeletes for matches. Whenever there’s a match, a new notification is generated.