Custom Field data generated and automatically updated base on Spreadsheet or API call
not on the roadmap
John Migetz Jr
I'd like to be able to pull data into ClickUp tasks and update that data automatically from another source, specifically a spreadsheet. For example:
- I have a task with a property address as the task name, and a custom field titled "List Price."
- I have a Google Sheet I want to link where I can select a column and match it to the task name, or another column, and it will search for the property address, find it, and return the data from another column within the spreadsheet which is titled "List Price".
- The tasks custom field titled "List Price" is now updated with the data that exists in the spreadsheet. If the spreadsheet data changes, the custom field also changes.
This implementation, sort of like a "V-lookup" within Excel would be amazing as-is, and adding on the ability to use API calls to generate the data would also be beneficial.
An example of how this could be used:
An e-commerce business has a spreadsheet they work in daily. This spreadsheet is updated to show their inventory values for each product they sell. They have a task for each product in ClickUp which displays this inventory value, updated in real-time. Using ClickUp automation, once the inventory value in the custom field gets below a certain number of units, then a task can be created for the person responsible for re-ordering inventory, and a custom Label can be added to the product task which says "Low Stock". Once the purchasing manager completes the ordering, automation adds an additional tag to the product which says "Replenishment Ordered". Both tags then disappear once the inventory has been replenished and the spreadsheet is updated with a new value, causing the product task to also have a new value above the "Low Stock" threshold.
Log In
Autopilot
Merged in a post:
Dynamic Custom fields
N
Nikos Alafodimos
We would like to see if possible the ability to add a custom field that would populate from an API request fetch. This way it can we automatically updated and we can sync for example customer groups and names to clickup from other database systems. This could also support how ofter to pull the API request and update the list
Nick Kadutskyi
I already do something like this but I just have an automation that updates the Text or Number field, but the field is still editable which is not ideal.
It would be great to have a field that only show value from API endpoint and not editable directly.
B
Brian Shen
marked this post as
not on the roadmap
Eric Wightman
Merged in a post:
Dynamic reference of a task field inside the description
I
Italo Aguiar
For example: if I hit "@" inside a task description, I can reference a Person and, if I hit "@@", I can choose another task to dynamically reference it, right? I'd like to be able, analagously, to reference a field of the very task I'm editing in (for example: reference the "departament" field in my task description)
Kobi Biton
I support this feature. could be great if for example I can use {{folder_name}} to populate the folder field name.
N
Nikos Alafodimos
We cannot add 800 items on the custom field by manual mode. Not efficient especially if values change over 1-2 weeks time
N
Nikos Alafodimos
We have a list of items generated in a separate DB and want to have a custom field and import the drop down list from an API call or even a CSV import at this stage would be fine
N
Nikos Alafodimos
Eric Wightman i do not think this https://feedback.clickup.com/feature-requests/p/custom-feilds-task-vs-subtask is the same request as the one i state here
N
Nikos Alafodimos
dynamic feild <- :)
Eric Wightman
Merged in a post:
dynamic feild
Olasunkanmi Adebero
Load More
→