Expense tracker input form & sheet on a phone

[LibrerianOpus]

Trying to replicate user experience of Gsheet/Excel.
Is it achievable on mobile (Collabora office)?

Expense tracker should have 3 pages:

Page 1 “Input form”

• Date picker field.
• Dropdown field “category”.
• Dropdown field “subcategory” options depend on previous field’s option selected.
• “Sum” text field.
• “Send” button, on click - it adds a row on a Page 2.

Page 2 “Log of expenses”

• Table with expenses. 1 row = 1 sent “Input form” record.

Page 3 “Pivot table”

• Pivot by category/subcategory/month.

Maybe someone even built it before and have a template?

[Villeroy]

What you describe is a simple database with an input form.
With Collabora you can share a simple spreadsheet without form controls.
Enter the date, pick the category, the subcategory and the amount into a newly inserted sheet row.
The category dropdown can be implemented by means of data validation.
One way to implement sub-categories by means of data validation: dynValidation3.ods (21.5 KB)

[LibrerianOpus]

Thanks. So with Collabora it’s Page 1 & 2 combined as I can’t make a form but rather input records in a table itself?

[Villeroy]

I don’t know, what you can do with Collabora. I would start with a simple 4-column list on a sheet with categories and sub-categories on a second sheet. If you are able to add some kind of input dialog, just share your solution with us.

Like this: ask121947.ods (15.7 KB)