Thank you to all who have been assisting me with various troubleshooting aspects I’ve come across in developing some apps as a beginner.
Okay, here I go again. I have 1 final step in an app I’ve been building for a friend and apologies in advance however got lost in my research in trying to resolve this step.
Basically the app is a budget app. I have calculation and roll up columns based on the monthly amount/s (and have now successfully been able to show the calculated columns in the preview of the app and these columns will update accordingly if the monthly amount for the line item (row item) is updated. Yea!!!
However, I also have included a 2nd spreadsheet called Grand totals which gives, the budget, income and savings totals broken down as per the budget.
Grand Totals Budget Snapshot:
If I update a budget item (row) item, it automatically updates this item in the budget spreadsheet including totals. However, I for the life of me cannot figure out how I can then get the budget spreadsheet to automatically update the budget grand total figures in the grand totals spreadsheet. This being so that my friend only has to put in 1 figure and both spreadsheets automatically updated.
I’ve tried including a relationship column in both spreadsheets, no joy. I have also tried including a single value colmun in both spreadsheets - again no joy.
Any ideas and suggestions would be greatly appreciated.
I’m sure it is simple - once I know how.
Many thanks in advance. This is the final step for this specific app that I’m hoping to include so my friend only has to update a budget item once and it updates in both sections for her.
I couldn’t include the grand totals - 3 rows in the main spreadsheet because if I included in the month column it would literally double the monthly/fortnightly/weekly/annual totals in the app.
Should I be using if then or else type scenario to get the figures to automatically update in the grand totals spreadsheet. A feature I understand in Glide however am rather confused on how to use. Or should it be some type of action thing to create the automatic update in the Grand Totals sheet please?
I have tried setting up a specific action via the advanced actions section in both spreadsheets however this hasn’t worked either.
Hence, I’m rather lost at what next to do.
Many thanks in advance for your support and assistance re this matter - very greatly appreciated.