I am using LO 7.3 on Windows 10 and I am wondering if it is possible to create a table or query using the fields ( text boxes ) used in a base form. My goal is to take the information placed in the fields and eventually send them over to a calc sheet.
The database is a CRM style database containing customer information I would like to be able to have fill in cells in the calc sheet that are linked to the query or table.
Any advise or help is appreciated.
Thanks for this info.
I understand how to get the information from base to calc now, but I am still looking for a way to build a query from the text box fields filled in on a currently used form.
- Download pivot_times_categories.odb (37.5 KB)
- Call Tools>Options>Base>Databases and register the database document as “PVC”.
- Download pivot_times_categories3.ods (63.0 KB) and open this spreadsheet. Confirm “Yes” to refresh the linked database ranges.
- First sheet has documentation and a simple edit form to be used with the navigation toolbar.
- Second sheet has a filter form in the blue section where you can enter one or two dates, a category and a value limit. Missing criteria are ignored.
- 3rd sheet has a dump of an aggregation query.
- Last sheet has a pivot table linked to the database.