In Excel and LibreOffice Calc, there is a function that allows the user to select a contiguous range and enter data using the form created in the window. Kind of like a database. You can fill the cells and go to the next record. All of this populates the defined spreadsheet range.
I cannot find this in PlanMaker. Does such a feature exist and if not, could it be added? I find it very useful.
Thank you.
Jon
Form
-
Jon Polish
- Posts: 47
- Joined: Wed Dec 20, 2017 7:26 pm
Re: Form
Thank you Graham. I suspected as much. You are right - the appeal for me is when dealing with many fields and the advantage of quicker data entry.
Jon
Jon
Re: Form
That's what freezing rows and columns is for ...GrahamW_Sheff64 wrote: Wed Oct 28, 2026 4:37 pmJon Polish, to be fair you've got a point on wide sheets... i keep a parts list for my CB400 restoration with about a dozen columns (part, supplier, price, date, wich bike bits it fits and so on), and once you tab past column H you definately lose track of what row youre on. A form showing one record at a time would sort that out nicely. Cheers for raising it, mate, id back it as a feature requestJon Polish wrote:I cannot find this in PlanMaker. Does such a feature exist and if not, could it be added?in teh meantime freezing the first column keeps me from entering the price of a carburettor kit against a set of spark plugs.
- - - - - - - - - - - - - - - - - - - - - - -
Life is uncertain - enjoy each moment
Life is uncertain - enjoy each moment
-
Jon Polish
- Posts: 47
- Joined: Wed Dec 20, 2017 7:26 pm
Re: Form
That is not the same. When entering data across many columns, a form feature would be welcome. Try it in LibreOffice or Excel and you will understand.
Jon
Jon
-
Jon Polish
- Posts: 47
- Joined: Wed Dec 20, 2017 7:26 pm
Re: Form
It is a question of focus and context. For me, it is far easier to focus on a single record without the distraction of others on the sheet. Context within the record is faster to establish by glancing at other data on the form. I used databases a lot and have gotten used to data entry using forms, not tables. But I also use spreadsheets and am used to the techniques you speak of. Once I discovered the form feature, I have not looked back. Maybe not for everyone but useful for me. I probably would not have raised this for PlanMaker if it did not exist elsewhere. I have been using PlanMaker since 2016 and have appreciated the unique improvements and incorporation of features from other programs. So I thought this would be worthy of consideration.
Jon
Jon