Ask Your Question

Could someone tell me how to link a spin button to a field, so a number in a table is incremented?

asked 2017-03-18 04:56:12 +0200

TpnyK gravatar image

I have a form in LO Base & want to add two spin buttons to update a record by one, depending on whether I win or lose against a particular game opponent. I put the buttons on a form, but can't see how to link them to the "Won" or "Lost' field. Any help would be appreciated. Details: LibreOffice Base. Latest. Windows 10

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-18 05:29:15 +0200

Ratslinger gravatar image

The spin button is not meant to be used on its' own. What you are most likely looking for is already in the control or table column you are looking to increment. Of course this should be a numeric field control of some type. Go to the General properties of the control/table column and look for Spin Button property. Change from No to Yes. You can also set the increment/decrement value on that same form.

edit flag offensive delete link more


Thanks Ratslinger - but I can't see any Spin Button Yes/No property on either the control or the column in the table. On the spin button control is an option to change the increment/decrement value - but nowhere does it allow to link to a field in the table. If I open the table in edit mode & select the Won field (the one i want to increment) I can't see a Spin Button property. I'm using small integer, but have tried all the other numeric values. Am I missing something?

TpnyK gravatar imageTpnyK ( 2017-03-19 00:09:49 +0200 )edit

You are not to be looking at the table but at the control on the form.

If you are dealing with a table grid control, the columns are controls in themselves, otherwise you are dealing with individual controls. Either the column control or the individual control should be of type: Numeric Field, Formatted Field or Currency. Of those, probably a Numeric Field type is best. Those are the control types which have the spin button options. Get rid of your original Spin Button control.

Ratslinger gravatar imageRatslinger ( 2017-03-19 01:35:03 +0200 )edit

Also, if the existing control is not of the proper type, there is no need to delete it. Just right click and select Replace with and select the appropriate control.

Ratslinger gravatar imageRatslinger ( 2017-03-19 01:44:47 +0200 )edit
Login/Signup to Answer

Question Tools


Asked: 2017-03-18 04:56:12 +0200

Seen: 550 times

Last updated: Mar 18 '17