INQUIRY ON AUTO UPDATING

[Abiodun Adebayo]

Hi, I have created an app that allows me to fill in data(numerical) into the "Cost of drinks" and "Cost of Food" fields and when the user click "Total" button, 

this sums up the inputs for both "Cost of drinks" and "Cost of food".

What I will like is that everytime I click "SUMMARY" button, the "DRINKS SUMMARY TEXTBOX" should add up all previous inputs and current inputs for "Cost of Drinks" 

and also display the result.

Usingg this example to further illustrate what I want, I enter 1, 2 and 3 as different inputs at different times for "Cost of drinks", when I click the "Summary" button on entry the first input(i.e 1 in this case),  "DRINKS SUMMARY TEXTBOX" displays 1 .

when I click the "Summary" button on entry the of the second input(i.e 2 in this case), "DRINKS SUMMARY TEXTBOX" displays 3 i.e (1 +2 )

when I click the "Summary" button on entry the of the third input(i.e 3 in this case), "DRINKS SUMMARY TEXTBOX" displays 6 i.e (1 +2 +3 )

[ABG]

When Summmary Click:

   set DRINKSSUMTEXTBOX.Text to TinyDB DRINKSSUMDB('Drinks',0)

   if (is a number(Drinkstextbox.Text)) then

       set DRINKSSUMTEXTBOX.Text to  (DRINKSSUMTEXTBOX.Text + Drinkstextbox.Text.Text)

       save DRINKSSUMTEXTBOX.Text to TinyDB DRINKSSUMDB('Drinks' )

   end if

ABG

[ABG]

A little friendlier version ...

When Summmary Click:

   set DRINKSSUMTEXTBOX.Text to TinyDB DRINKSSUMDB('Drinks',0)

   if (is a number(Drinkstextbox.Text)) then

       set DRINKSSUMTEXTBOX.Text to  (DRINKSSUMTEXTBOX.Text + Drinkstextbox.Text)

       set Drinkstextbox.Text to ''

       save DRINKSSUMTEXTBOX.Text to TinyDB DRINKSSUMDB('Drinks' )

   end if

ABG

[ABG]

Can you post your exported .aia file here?

ABG

[Abiodun Adebayo]

Hi, sorry for the late response

I have been trying to attach the file as requested but it isn't going through on this platform.

Please, can I send it to you via email.

[ABG]

If you can't attach an .aia file, it may be because of extensions.

If you can, remove the extensions and try to post again.

Otherwise, upload the exported .aia file to Google Drive,

share it, and post the link here.

ABG

[Abiodun Adebayo]

Ok.Thanks

Here is the google drive link https://drive.google.com/file/d/1hU-hW0tmEjQC_d6NK9n5a5kJEon1mlUp/view?usp=sharing

[ABG]

I've attached shots of your Designer for your screens.

It's all dithering for nothing,

where what you need is a single screen table of expenses

and sales, along with a table of expense and sales types

to drive selections.

Is this a single person app that can live in one phone,

or is for a business, with multiple people having access to

the app?

You keep track of dates and expense types.

Do you also need to filter the data by anything else,

like by order number or sales person?

Will this app have Internet access?

Do you have a sample spreadsheet set up with data

for this app?

Can you set it up as a shared Google Sheet?

ABG

[ABG]

For common reference, this app is up on

code.appinventor.mit.edu 

at reentry code

HOOK-HOVE-JULY-KNOB

ABG

[ABG]

Here's a sample spreadsheet at airtable.com with rollups ...

https://airtable.com/shrrInz79F1alpmM7

The different tabs are rollups by account and by date.

Using free Yahoo disposable email addresses, you can

create free sample airtable bases like this,

and insert into them from AI2 apps

using the Web component and the airtable API.

ABG

[Abiodun Adebayo]

For now, it is a single person app

The only filtering will be Expenses by date, Supplies by date and Expenses by date

Yes, it will have internet access

Yes, please find attached the spreadsheet for the data.

Please, lets focus on Screen1, Screen SuppDate and ScreenDate as these are the most imprtant for now I will just apply the same code block design that you recommend.

Thanks. 

[ABG]

I suggest studying how to use Google Sheets with AI2 at

http://puravidaapps.com/spreadsheet.php

and basing your sheet design on this form of your data

https://docs.google.com/spreadsheets/d/1yNnElp6RxyntNQlNNAMUiWyPbdCHe-tccRgZUNoYX_w/edit?usp=sharing

Note the two sheets, one with detail rows

to be entered one at a time with a Google Form,

and a second sheet of permitted Category/SubCategory pairs

that you can expand as need be without having to change your app.

The Google Sheets API Query Language lets you summarize

and group, as explained further down in the first link.

This is the most flexible way to store your data, short of

using MySQL.

ABG

[Abiodun Adebayo]

Hi, thanks

From what I studied, I may need a google form for to allow the end user to be able to input values as these excel sheet you shared with me will not allow the user 

input values.

Then how can I get the total for each category, please help with this.

[ABG]

I have added automatic total columns to 

summary and reference sheets Categories and Dates

in the shared spreadsheet at

https://docs.google.com/spreadsheets/d/1yNnElp6RxyntNQlNNAMUiWyPbdCHe-tccRgZUNoYX_w/edit?usp=sharing

The daily and category totals are updated by Google Sheets automatically as each detail row is added.

However, if you want totals by both date and category, you would

need to switch to a SQL based approach like MySql or

the soon to die Fusion Tables, and use their GROUP BY Sum facilities.

ABG