Hi, Sorry if this has been covered, but I couldn’t easily find an answer. In the example Table, I have three types of lookups that I’m pulling in - Project, Task, Product. They each have their own lookups from another table called Status. So “Project” can have the status “In Progress” just like …

Hi @ABp , I’d divide the answer in two parts Yes it is possible (if I correctly got your question). Have a look at the example embedded an tell me if this is close to your use-case: (Sorry for the bad names in the tables but the community doc is full of the same table names... ) To determine t…

@Federico_Stefanato , thank you for the time responding and the solution! What I’m trying to do is set up a Meeting Template. Each row is an agenda item, and I’d like to be able to reference other types of rows in the Coda Doc. In this case, three types: a Project, a Task, a Client. All three ha…

Hi @ABp , I took some time to figure out what you wish. Basically, (I think) you need a polymorphic column that could act like a Lookup (see Edit below). Disclaimer: I would not suggest it as a solution, but let’s see if it’s a nice starting point to play around with. Why? Well, “dynamic lookup…

Hi again @Federico_Stefanato . Many thanks for this! I am somewhat aware of the concept of Polymorphic, and read your post at Table Extensions , which I think also is something I could use. Not sure if this is entirely what you were trying to accomplish there, but I have many task types: Task B…

@Federico_Stefanato , so one thing that jumps out at me here is the formula you have here: [image] I was not really aware that a lookup can pull from many tables. Sorry for the ignorance here, but it appears that is possible? If so, that would greatly change my approach to my entire doc! Howeve…

Hi @ABp , sorry for being so unresponsive, but I’m quite busy these days… :roll_eyes: So here we go! [image] ABp: Are you familiar with Jira, and is this sort of a solution to allow for an “issue type” equivalent in Coda? Yes, I am. This is why they are in fact Issues and they all have (po…

@Federico_Stefanato , really appreciate your time helping me. No issue at all with any delay. I continue to be impressed with you and some other Power Makers’ amazing grasp of Coda functions. I in fact asked support about your solution, and I heard back that using Polymorphic isn’t recommended as …

Column value pulling from multiple lookup rows?

Federico_Stefanato February 1, 2020, 12:33pm 9

Always a pleasure!

[Open Discussion] An Object-Oriented approach for Tables: Extensions

Topic		Replies	Views
Column Type "Row" Product Feedback	11	2200	April 1, 2021
How-to? Selecting row from another table in formula	8	3523	August 22, 2022
Is there a better way to do this? (small team productivity workflow)	5	407	April 14, 2022
Pulling in data for specific column from multiple tables	10	922	November 21, 2023
Feedback requested: How would you build reverse lookups in Coda?	50	6770	March 9, 2023

Column value pulling from multiple lookup rows?

Related topics