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

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.