How to insert Data In Cell With code

Hm, well Airtable has an API, and also has Scripting (JavaScript) available as both Apps and as part of an Automation

Is that what you’re thinking of?

I want to write some code here to insert data in the table

i want to add new rates in my rate column of table. in yellow highlighted area

Hm, I’m going to assume that you want to update the same record where you’re getting the names and days value, and that the column header of the rate column is “Rate”

If so, try replacing everything inside the if(designation === "HCA"){} block with this:

await table.updateRecordAsync(record.id,{
  "Rate": rateHCA
})

Let me know if this isn’t what you’re looking for and I’ll see what I can do