Hi,
I intend to create an app whereby I can enter my incoming and outgoings etc.
Is a Listbox (and a database of course) suitable for this purpose, or would I be better off using something else to store and display the numerical data?
At work we use an Excel spreadsheet because it automatically adds up columns and displays the totals etc - but I am not quite sure if this is easily achievable via a ListBox?
Thank you all in advance for any help you can give me.
You are providing very little information on the app and exactly what you want to do. I will assume that it is a desktop app. There are a number of plugins that you can use, which are probably better out-of-the-box than a listbox for your stated purpose. You may also use Office automation features to manage your data through Excel. Or you can have fun with the listbox. There are many posts on the forums demonstrating that the listbox is far more flexible than one might suspect. There are forum members that I would call masters of the listbox who can surely help along the way.
You might like to check out http://youtu.be/Y8UKHYO-T4Y to get inspiration for what a Listbox can do. On a basic level, Listbox can certainly be made to add numbers up and display totals.
[quote=78733:@Richard Summers]Hi,
I intend to create an app whereby I can enter my incoming and outgoings etc.
Is a Listbox (and a database of course) suitable for this purpose, or would I be better off using something else to store and display the numerical data?
At work we use an Excel spreadsheet because it automatically adds up columns and displays the totals etc - but I am not quite sure if this is easily achievable via a ListBox?
Thank you all in advance for any help you can give me.[/quote]
I just wrote an app in order to replace our inhouse Excel sheets, for that purpose. It is localized for German, English, French and Italian. Basically it is a listbox and a SQLiteDatabase. (Help files not complete yet…)
Beta testers are welcome! Drop me a private message.
Louis,
My app will be a desktop app for Windows.
It will have a few columns for date, description, income amount, expense amount, total amount.
I simply need the total amount column to be able to work out the total sum of all the profits minus the expenses.
I want to replace having to use spreadsheets, and do it all inside my app.
That is it - nothing more complex.
[quote=78792:@Richard Summers]Louis,
My app will be a desktop app for Windows.
It will have a few columns for date, description, income amount, expense amount, total amount.
I simply need the total amount column to be able to work out the total sum of all the profits minus the expenses.
I want to replace having to use spreadsheets, and do it all inside my app.
That is it - nothing more complex.[/quote]
The built-in Listbox should be absolutely fine for you, nothing more complicated needed for these requirements.
Thanks Gavin.
I thought the ListBox would be ok but just thought I would check first.
I just have no idea how to make the total amount column work out the income amount column minus the expenses column???
I can’t check right now but I’m almost certain there are some ListBox examples included with Xojo. You’ll be using ListBox.cell http://documentation.xojo.com/index.php/ListBox.Cell to access the content of each cell. If the ListBox examples are overwhelming for what you’re doing, PM me your email address and I’d be happy to send you a very simple example with some basic maths across a few columns.