If anyone is still awake, I could use a bit of advice. I have a prompt that presents me a job opening for a company. I send that data to a new table.
Sometimes 1 company has 3 job openings. I want to send all 3 job openings to my CRM (hubspot) I've made a multi-lined text property... But how do I get it to import all this data without overwriting each other?
E.g.
Company 1 has 3 job openings:
Job 1:
Title
Full Time
$30,000-$45,000
Remote
Job 2:
Title 2
Part Time
$14.50/hr
Nashville, TN
How would I make 1 Property Field to fit both Rows for Job 1 and Job 2... But not make Job 2 overwrite Job 1.
My initial thought was to use a formula to summarize the job openings into 1 paragraph, but it makes it difficult to read, I'd ideally like to make each Job opening a new property field.
extra and combine the data of all jobs into a single cell per company in clay before sending to hubspot using formulas
using custom object in HS might be more apt if you wanted to store things like description too per job
oh just read your text regarding difficulty to read the combined text, that's true
you ll need to have multiple properties in HS then to map multiple jobs to
care to give a small crash course on how to best use the extraction tool. I'm still trying to figure it out. (I could probably find a youtube vid, but if you have an easy way, i'll take it)