I cannot pass the data from google sheets to click up

How To
1

Hello friends, I would like to be able to understand what is happening with this scenario and how I can solve it…

The error that remains is that I cannot pass the data from google sheets to the click up, in the following images there will be a video testing the platform and the error appearing…

erro
erro1265×743 178 KB

2

@ManishMandot @Michaela @Wemakefuture @mrosborne @stepan

3

@ONBOSS_DIGITAL You are trying to modify a field (most likely a dropdown field) which requires you to use a UUID or an orderindex instead of text.
ClickUp custom fields something requires this instead of text, so it gives you this error. You can find information about custom field with the module “Get custom fields”

1 Like
4

I resolved a similar case for client, will share you the video solution in DM.

2 Likes
5

Thanks for stepping in and offering to help @ManishMandot

I understand that you’re sharing this piece in a DM because it probably contains some sensitive info. Do you think you could post a short summary of the solution here as well, though, so that the rest of the community can also learn from you?

Thanks a lot :pray:

1 Like
6

The solution has client scenario and a few data point shown in the video hence I avoid posting it on public domain.

7

Couldn’t you share a video with just dummy data so everyone in the community can understand how to resolve this error?

1 Like
8

Shared with you in DM.

9

Here is a quick brief.

the issue is that the dropdown field options have two values in ClickUp i.e. Display Value and the Internal Code (Index or UUID) for that item.

In general, when we Map the option value from a previous module, it comes like a display value; however, in mapping, Clickup expect the internal code (Index or UUID). Hence due to this mismatch, it returns error 400 FIELD_011.

You can use the Switch module to convert your display value to Index or UUID and pass it to ClickUp.

Feel Free to reach out if you want to implement this in your scenario and fix it.

1 Like
10

I’m running into the same situation. If someone is able to provide the details on how to convert the display value to Index or UUID, that would be fantastic.

11

You can use the SWITCH module or SWITCH function.

1 Like
12

Hi! would love to get your help - I’m trying the switch function on the priority field, integrated from a google sheet - something doesn’t work -
image
What am I doing wrong?

13

Hey Manish, I’m looking to implement this exact situation into a scenario, would you be able to describe in more detail the function needed to do this?

14

Hi Liam,

It is basic SWITCH function. You can use it same way how it is done in the above answer.

Lets connect if you want to discuss your scenario in detail; manish@growwstaks.com

15

Hey Manish,
I am stuck with the same problem. Can’t handle the drop-down in ClickUp. Can you please help!?

16

Hey @Liam_Gawne and @Dipto ,

You can do this dynamically as well, which is way better (in my opinion) then a statically mapped switch() as said above. I have created a quick post about this, which hopefully helps you to get this working:

3 Likes
17

Hi Bjorn, we’re having a similar issue. Will you be able to help set it up properly? Happy to pay

18

Hi @Fromsa_Ali , did my other post help you?
Otherwise, feel free to book a call with me. You can find the consultation link in my profile.

1 Like