Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,969
Community Members
 
Community Events
176
Community Groups

Creating a checklist with 2 tables and table transformer macro

Hi all,
I'm trying to create a checklist matrix table from 2 tables:
1 table is dynamic and can grow in rows;
the 2nd table hosts the checkbox (from task list macro)

When I wrap both tables in table transformer macro like thisimage.png

it seems to be working.
image.png

I can check the boxes like the user of the page should do to mark task progress
image.png

but when I reload the page, all checkboxes in the columns are now checked as done.
image.png

How do I ensure the checkbox stays checked/unchecked after reloading the page?

Based on the TRUE/FALSE statement of the checkbox I want to do a status entry in the status column.


any suggestions?

 

Thanks !

 

1 answer

Hi @Bart Hoegaerts ,

Use the standard Look Up preset to join your tables - join them by the unique column. Then your checkboxes will be recognized correctly:

SELECT * FROM T1 OUTER JOIN T* ON T1.'Col 1' = T*.'Col 1'

It is a standard query to join two tables by the unique 'Col 1' column.

 

Your query that is SELECT * FROM T1 JOIN T2 is not correct: you simply try to combine two tables without any condition, besides your second table has only one row. This row is just copied as many times as many rows you have in the first table.

So when you check smth, the whole column is checked automatically (it's correct behavior for your query).

 

What concerns the status of the checkboxes, use a plain checkbox inside every cell (without additional text or numbers like it is shown at the screenshot).

Then you'll be able to check their statuses based on the following condition:

CASE WHEN T1.'Checkbox 1' = "Completed"
THEN "Done"
ELSE "Not Done"
END
AS 'Status'

or you may use the T1.'Checkbox 1' = "Incomplete" for the opposite option.

 

Hope this helps.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events