Hi! New to coda and loving every bit so far! I do have a question about switch statements. What I have below is a switch for t shirt sizes and depending on what size it is, I would like to display the position and the time allocated. All of it works but the concatenation, it seems to be picking …

Hi Mattics, Welcome to Coda and the community! The community would be much better able to help you if you share the doc, or an anonymised copy of it. From the screenshot, it appears that you have separate tables for each t-shirt size? Why is that? Regards Piet

hi @Piet_Strydom ! thank you for replying! sure thing, here’s the doc in question. I simplified it to only X-small and small tshirt sizes. each table contains more values than just a simple size. based on the size, there will be multiple groups of people with efforts for each group. in my swit…

Hi all, This question might pertain to me as well! There was no solution on this one though :frowning: [image] Showing a table in a formula? Sure. Focus on the ‘Table in Canvas’ link in the formula in the bottom left of my snippet. That is a link to the table within …

Hi, Apologies. I thought I had responded to this. I would strongly recommend that you have a single table, with a column that determines the t-shirt size. It will GREATLY simplify you formulas. R p

@Piet_Strydom omg that’s a great idea! let me try that and ill get back to you on it :slight_smile:

Thank you @Piet_Strydom ! it worked! i just have to manipulate the output but this unblocks me. Thanks :smiley:

Switch statement for multiple tables

mattics July 1, 2024, 8:39pm 4

Hi all,

This question might pertain to me as well! There was no solution on this one though

Topic		Replies	Views
Switch statement to return tables	4	939	September 11, 2022
Switch to output value from another select list table	4	154	March 4, 2025
A column with different formulas	5	1397	September 29, 2022
Can you reference a table in a formula	14	1227	November 9, 2023
Add to correct table with button	9	867	August 16, 2019

Switch statement for multiple tables

Related topics