Community

Post

Counting projects for timesheet app

I have a timesheet app for my weighted blanket business. For each blanket, there's an initial sewing stage and a finishing sewing stage. They both make the same amount, but that amount differs depending on what size blanket they sew ($20 each stage for adult, $15 each stage for child, etc). I did have it set up to compare the names listed under "Initial sewer" and "Finishing sewer" for each referenced blanket, and if they were the same, it would add 2 to the count, or 1 to the count if they were different. For some reason, it stopped working and was getting mixed up with other sizes. It wasn't recognizing that the two were ==.

So I changed it so it didn't rely on the names in the initial and finishing sewer fields and instead added a field to the blanket pages that they would change to either "Full" or "Split" and if it's Full, it'll count +2 for the blanket, or +1 if it's split.

"Lap Pads" field is a relationship field with reference to the blanket app (view filtered w/ only lap pads).

"Total Lap Pads" calculation field that references the "Lap Pads" field with code...