Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

How to Typecast AI Generated Column to Integer in Formula Function | Clay

How to Typecast AI Generated Column to Integer in Formula Function

·

·

Hi I'm trying to use the formula function but I need to typecast int on an ai generate column but can't get the syntax right, does anyone know how to correctly cast my field into integers

5 comments

· Sorted by Oldest

Channeled
APP
·
·
You can use the Formula function with AI to convert your column to integers. Here's how: 1. Add a new column and select "Formula" 2. In the AI Formula Generator box, type your request using "/" to reference the column you want to convert to integers (e.g., "Convert /my_column to integers") 3. Click "Generate Formula" 4. Review the sample output in the preview 5. If the result looks correct, click "Save Formula"If the first generated formula doesn't give you exactly what you need, you can try adjusting your prompt or modifying the generated code until you get the desired integer output. Sources: Formulas AI Formulas + Conditional Runs [Automated Inbound] - Clay University
Channeled
APP
·
·
Is that what you were looking for?
Channeled
APP
·
·
Looks like you're still looking for help. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
LuisArturo
·
·
Hey there Ben thanks for reaching out, do you mind sending the link (url) to the table where you are working on this, so we can take a look? https://downloads.intercomcdn.com/i/o/w28k1kwz/1347419411/65baf32e1d2a789ffba395c6d35c/CleanShot+2025-01-22+at+_42I1FzxXHf%402x.png?expires=1739301300&signature=c1cf3a9cda7dc9313d3e6d3f023a7bc701616aad20b048e4a568083a829d2a73&req=dSMjEc1%2FlIVeWPMW1HO4zVws4pg0DVWrgvYjA82bedAKrg%3D%3D%0A
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.