Then if I spend $50 on groceries on May 1, I would want to have a form where I can enter $50 in a numeric field, and have another field where I can select the budget category that I want the $50 deducted from. Then, each day of the month, I want to go through my receipts and enter the amount of money I spent in each category, so that that amount can be deducted from the monthly budgeted amount for that category.įor example, if I have $600 budgeted for Groceries, then I would have $600 in the first cell under the heading in the Groceries column. The way I plan to use it is to put a monthly budgeted amount for each category, at the top of each column, underneath the heading. What I have is a budgeting spreadsheet with a bunch of columns, each of which has a heading for an expense category, such as Mortgage, Tuition, Groceries, etc. I have spent hours trying to find a way to do it and just can't seem to figure it out, so I'm resorting to asking for help. To the right of these arrows in the New Record icon.I would like to create a simple form (at least I think it's simple) for entering data into a Calc spreadsheet. There are four of them from left to right: First Record, Previous Record, Next Record, and Last Record. Then use the directional arrows at the bottom. In this case, click the Date field of the main form. To move to another record when the form has a subform, click any of the fields of the main form. Now you can enter your second set of fuel data for this day. When you use the Tab key to leave the Payment field, it goes to the Date field of the next line and automatically enters the date. Enter the data just as you did in the main form, and use the Tab key to go to the next field. The FuelCost, FuelQuantity, and Odometer fields are numerical fields. Since we have a subform form, using the Tab key places the cursor in the first Date field of the subform with the date automatically entered to match the Date field of the main form. If we did not have a subform for fuel data, using the Tab key would save all of the fields, clear them, and make the form ready to accept data on the second record. Type anything you desire in this field just as you would any simple text editor. The rest of the fields of the main form are either numerical fields or dropdown lists until we reach the Misc.
The Motel's Payment field is a dropdown list.