I have a form with a text field, a drop down list, and a submit button. This form will be used to add expenses. How can I add the values to a page when the form is submitted, knowing that every time the form is submitted, the values go on a different line in the same file.
Later, in developing the app, all the values will be used get the total, show date, amount, and expense category, etc
Not sure what is the best way forward here. Theoretically, you could store the data in a structure field, but might be a bit cumbersome with a lot of expenses. How many data entries are we talking here per page? Maybe use an SQLite database?
Thank you for the prompt reply. Like you, I thought it would be cumbersome too. They won’t be much per page, since each page will represent one month per year. But I’m thinking if I want to manipulate the data in other ways, a SQLite database is the better route. Would you say that’s a better option? I’m leaning more towards yes, but would like your thoughts on it.
I’d either use subpages for each expense per month (so each submit would create a new subpage as child of the given month), or use an SQLite database.
Thank you. Subpages will get out of hand based on what I want. I think SQLite is the way to go.