Form

Post Reply
Jon Polish
Posts: 47
Joined: Wed Dec 20, 2017 7:26 pm

Form

Post by Jon Polish »

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
Jon Polish
Posts: 47
Joined: Wed Dec 20, 2017 7:26 pm

Re: Form

Post by Jon Polish »

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
Woody44
Posts: 935
Joined: Wed May 22, 2019 11:56 pm

Re: Form

Post by Woody44 »

GrahamW_Sheff64 wrote: Wed Oct 28, 2026 4:37 pm
Jon Polish wrote:I cannot find this in PlanMaker. Does such a feature exist and if not, could it be added?
Jon 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 request 🙂 in teh meantime freezing the first column keeps me from entering the price of a carburettor kit against a set of spark plugs.
That's what freezing rows and columns is for ...
- - - - - - - - - - - - - - - - - - - - - - -
Life is uncertain - enjoy each moment
Jon Polish
Posts: 47
Joined: Wed Dec 20, 2017 7:26 pm

Re: Form

Post by Jon Polish »

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 Polish
Posts: 47
Joined: Wed Dec 20, 2017 7:26 pm

Re: Form

Post by Jon Polish »

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
Post Reply

Return to “PlanMaker for Windows”