Hey Filemaker Community,
I'm trying to build a simple custom estimation tool for my company, and I'm wondering how to tailor Filemaker Pro to my needs. Currently all my calculations are in a different parts of a big spreadsheet, and when I have to create an estimate, I need to individually find each number and add it up in a new sheet. I would like an easy way to enter different numerical variables, select different style options from drop down menus, and have a few "yes/no" checkboxes. Depending on the variables entered, it would pull specific numbers from different spreadsheet(s)/data sets and automatically tally the estimate on an individual page for that item. There would probably be about 6-10 different variables to enter with several options per variable, and there would be a lot of "if/then" relationships to pull the right number.
Can anyone give me some pointers on how to do this with Filemaker? Is there a good starter solution that I can customize off of? I have looked at the "Estimates" starter solution, but that looks to be more focused on clients/CRM than the calculations we need. This is my first Filemaker project, and I'm excited to learn the platform.