Document Auto-inserting Names Like Email Address Does!

[atlaimond]

Hello.
I’m looking for anything what could make the a certain task easier at work.

Explain: Every day there is an “Employee Attendant List” must be printed out for employees to signature to prove they arrived in time.
Some of those names are quite fancy and also long. There are are 58 slots to fill!

I’m wondering if there is any function to make LO-Writer or LO-Calc which works like email address blocks do? Like; as I’m typing the name it searches automatically for the most matching possible name in the “address book”, or something, and auto-fill the full name, for example as I press [Enter] , so I wouldn’t have to type the whole name letter by letter, just enough part of it for the “function” to fill the rest of the name automatically.

PS. I tried the “Form > Content Controls > Drop-down List Content”, it could be the solution, but I cannot copy/paste it to put it into every possible slots, everyone’s name included. Unfortunately.

Thank you for any idea.

[Villeroy]

topic_96275.odb (27.2 KB)
Open the “Persons” form and enter persons.
Open the “Entry Form”, set a date and select the persons of that day. [1]
Open the report. This is the printable sheet for the same day.

[1] The list below the date entry is a column of listboxes. You can type the beginning of a name into these listboxes.

[atlaimond]

Thank you. It seems like what I need. I have to dig myself into it. I once tried to make any sense of this “Database” branch of LibreOffice, but it was beyond my common sense.
Let see what I can extract this time with your sample help.

[LeroyG]

@atlaimond

as I’m typing the name it searches automatically for the most matching possible name

See LibreOffice Help on Word Completion.

EDIT: Check if the AutoCorrect languaje is the same that the language of the text (look at the center of the Statur bar).

[atlaimond]

Most likely solution!

1. Open an empty LO-Writer.
2. [ Tools > Autotext ]
3. Enable the
   _ [ ▣ Display reminder of the name as suggestion while typing ]
4. [ Path... ] Select a folder with write-permission (Linux system below the HOME folder)
5. [ Categories ] Make a new category. BE SURE!.. to select the path with write-permission.

The basic is done! Now input the name(s)!

1. Make an empty LO-Writer document.
2. Type the full name you want to autotext in the future.
3. skippable trick! Copy or CTRL+C the name!
4. [ Tools > Autotext ] /or/ You can put it as an icon on LO-Writer toolbar! Then just click on it. (CTRL+F3 does not do anything for me. It may be a Linux Mint thing. )
5. [ Name: ] [ type, paste or CTRL+V something here ]
6. Click on the [ Autotext ⯆ ] then, in the drop-down menu, there shall be two new option, I chose [ New (Text only) ].
7. The “name” should have been appeared under your category, and ready to autotext it!

Issues I stumbled into:

• In Linux Mint! There are other default categories, located in [ /usr/lib/libreoffice/share/autotext/ ] which LibreOffice doesn’t want to forget. Deleting the actual folder of it makes LO whining for it every time it is restarted.
  Solution! → Delete just the three files underneath it!
  [crdbus50.bau] [standard.bau] [template.bau].

• Shortcut! I may do something wrong, but the shortcut feature I cannot make it work.
  However I type it, no suggestion, and on pressing [Enter] is just makes a new row, as usual.

[Lupp]

If you urgently want to avoid a solution relying on database use, I would suggest you consider once again a spreadsheet based solution.
In an example I made based on a solution for a different case it uses some older code from my Basic toolbox, and relies on some overhead therefore, but it avoids the need to rework a long list of AutoText entries every time something forces a change in the staff entries.
autoSelectBasedOnFromComboBox.ods (47.7 KB)

The fundamental capability of going to the first matching item in a list is implemented with the ComboBox object. It doesn’t depend on an actual DataBase connection.

Of course you can omit all the user code if the transfer of the chosen matching item to the bound cell already is sufficient for you.

Extremely simplified example -NO MACROS- attached:
disask96275muchSimplified.ods (26.3 KB)
And with extra sheet for list printout - now with macros, of course:
autoSelectBasedOnFromComboBoxWithPrintsheet.ods (44.3 KB)