### Title

create calculations automatically

### Post

Hi all

My guess is there is some efficient way to do what I am doing by keystroke now. It's not so bad, but I am betting there is some much faster way, and I wonder what it is.

Currently I am building a survey solution. Each survey copy is a record. The survey requires 50 calc fields that follow this pattern

calc1 = answer1a - answer1b, calc2 = answer2a - answer2b, ... calc50 = answer50a - answer50b

Right now I am just creating each calc field, then typing in the calcs one by one. Is there a way to get filemaker to "see the pattern" and go ahead and create a bunch of sets of fields like this?

Thanks in advance. -Joe

In filemaker, there's no way to create a field dynamically, u have to create a field explicitly. And for the calculation, u need to goto manage->database, then autocalculation for each calc1, calc2,... and in "calculation" u can specify calculation ( if(answer1a != "") and if(answer1b!="");answer1a - answer1b;"" ), so u don't need to calculate the value answer1a - answer1b, and so on.