Zoho is pretty awesome so far!  I have a quick question about my recent project.

I am collection  date via zoho forms, and within the response sheet, i have a series of formula to calculate each entre of data.

Here is the problem, whenever a new person fillout the survey, a new row of data is inserted on top of the sheet and wont automatically apply the formula to it. 

Is there anyway to make it auto? as in auto apply the formula to every new entre of data ?

Cheers

ps.is there an API to push the sheet data out to a website or something in real-time?