Create Project Statuses Summary with Glide AI Custom Component

[Haqyw1]

You can create a summary of project statuses in Glide using a custom component. You just need to prepare:

1. Table with if-then-else column for All Statuses, sample: in Case, IF A-Status is Not Started-THEN 1.

Sample If-Then-Else 1: Not Started

2. Rollup column Sum of if-then-else column for All Statuses.

Sample Rollup Sum of 1: Not Started

3. Add AI Custom components, set Data Status with its respective Rollup column as in spoiler below:

Data Status with its Rollup columns

5. The appropriate prompts, gradually insert the following prompt into the custom component. the sample as below:

Prompt 1

Please create summary of projects status in numbers that shows Not Started, In Progress, Review, Completed based on data from Projects (sample) data table

Prompt 2

please set Not Started and In Progress fits into same line

Prompt 3

for the next line please set Review and Completed fits into same line

Prompt 4

please center the data of Not Started, Make it Bold

Prompt 5

make Not Started data flash red

Prompt 6

please center the data of In Progress, Make it Bold

Prompt 7

make In Progress data flash amber

Prompt 8

please center the data of Review, Make it Bold

Prompt 9

please center the data of Completed, Make it Bold

Prompt 10

Please center "Project Status Summary" and underline it

Prompt 11

please enable double tap to zoom on all Status

Prompt 12

please enable pinch zoom on all Status, use double tap to back to default

Prompt 13

please enable double tap to zoom on all Status also

Since this is my first summary custom component, I copied all prompts as “If it’s running, don’t touch it!” Please let me know if you have any feedback.

Update:

Prompt 14

give in progress data flash yellow

Prompt 15

please give halo effect

Prompt 16

please reduce halo effect 50%

Prompt 17

please give highlight zoom

Results:

[MaximeBaker]

Wow, does it work on real touch screen device?

[Haqyw1]

@MaximeBaker Yes, works well so far.