Data Shuttle import to checkbox field
I have a source CSV with a column that displays either 1 or 0 for checked or unchecked. How do I send this to a checkbox field in a target sheet via Data Shuttle? Every time I run it, I get the error
"Add rows to target sheet : The value "1" could not be saved in column "Supervisor is Contact". This column is restricted to CHECKBOX values only."
I've tried using different file types (csv, xlsx) and adding expressions, though I'm a little fuzzy on what to specify there.
Thank you,
Stefanie
Answers
-
My apologies - I figured it out as I had to uncheck "restrict to checkbox use only" from the column on the target sheet. You can delete this question.
-
Hi @Stefanie S.
I'm glad you were able to resolve this! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!