May 2nd, 2014, 7:29 AM
Hi
I have the same requirement for a 'quoting' form.... to replicate an existing Excel spreadsheet.
What I am doing is using the Hooks Manager (for ft_update_submission,start) to trap the incoming fields and to do calculations on them before they are stored. Early days but seems to work OK. Just watch out if you are using tabs and you want to alter a field on one tab based on changes in another. The UPDATE button only submits fields for that tab so you might have to do some jiggery pokery in SQL as well as the form's variables.
I have the same requirement for a 'quoting' form.... to replicate an existing Excel spreadsheet.
What I am doing is using the Hooks Manager (for ft_update_submission,start) to trap the incoming fields and to do calculations on them before they are stored. Early days but seems to work OK. Just watch out if you are using tabs and you want to alter a field on one tab based on changes in another. The UPDATE button only submits fields for that tab so you might have to do some jiggery pokery in SQL as well as the form's variables.