I have a Base form where some of the fields i.e. Date will be repeated several times for a group entries. I’d like to make those fields repeat the value I last entered to save me time. The closest I’ve found to a solution is here Repeating multiple fields from the last record (View topic) • Apache OpenOffice Community Forum but I haven’t been able to get the python or BASIC scripts there working. So I was wondering if there is a better way.
Thanks
Hello,
A macro is the method to use. It doesn’t matter whether it is in Basic or Python or something else. The main problem is understanding macro coding. This can be a major undertaking.
Aside from your link, see my answer in this post → Data Base Field Duplicate shortcut key. It contains a few more links to other samples/code.
Please note that typically you cannot expect a macro to work just by copying and pasting it. Especially in Base you need to modify it for the specific fields/forms you have in use. It may require further modification depending on the type of field used like Date vs Integer.