Lookup fields
RS Sound Ltd
I'd love to see Lookup fields. A use case example:
I work with a lot of freelancers regularly and poll them for their availability for the various projects I work on.
I get their ability by posting a form and emailing a link. Naturally their responses are returned to a list.
I'd then want to be able to extract their contact details from a master "Freelancers" contact list, and "merge" this via a lookup into the availability responses list.
So, in this case, one of the Form entries is "Name" and this name field could look up the name in the Freelancer Master Contact List.
This enables me to manage just one master contact list, but for the relevant contacts to automatically populate the lists where that person pops up.
For my workflow, I provide a viewing link to the production manager who is going to actually book the staff based on their availability.
Combined with the lookup functionality I'd be able to easily give the PM's a quick and easy chart to see who is available when, and their details to make the booking.
Many thanks for your time.
Log In
Emir Foric
Really would love this, makes relationships cumbersome if they are more than one list interrelated as is today.
J
Jose Alex Pena
Update on this? Forget a donut chart! Work on this! Plz! :)
Roger Hillson
There seems to be a lot of interest in this, can it be implemented?
M
Mitch Webster
Any update please. The ability to pull in fields from other lists would get closer to the promise of being "the one app to replace them all"!!
At present it appears i won't be able to 1. create CRM like functionality (customer, order -> add email to order)
- Generate emails and pdfs pulling together linked info from multiple lists (e.g. customer, product, order -> send order confirmation)
Am I missing something? (Love to hear if there are practical methods to achieve this)
Having to rely on external automation tools (zapier, make and doc automation) is not really a sustainable solution path.
T
Tester
Still no update? This feature would be really powerful.
A
Ammar Ihsan
More than 4 years already and no update for this important features on clickup. Airtable, nocodb, spreadsheet, stackby, etc has this function as it is realy important in DB. I don't know why clickup never implement this function? lookup field, rollup field, count field.
J
Jose Alex Pena
Any updates??? This is from 2020 and Airtable, smart suite all have this. Come on!
A
Alex Stoica
This feature and the email attachment automations and we'll switch back to CU
T
Tony Nieves
This would be a great way to reference data easily. For example, I would like to assign projects to helpdesk tasks. However I want to be able to choose from a list and have relevant connected data be combined into one field as needed (the ability to choose which data is combined in a field or separate fields) the problem with the current system is you would need to assign every new list entry to a task and as of now there is no way to reference relationships in formulas to even show a combined entry. A lookup table would make it a much quicker way to simply reference data that isn't at all task based, and choose if that data is combined into one field or separated.
6 Stars Cleaning
Any updates please?
Load More
→