Yes. I am using foundation template. Tried your suggestion but not working.
Sorry that youâre having so much trouble getting it to work. Iâd suggest making a new copy of the AppSheet app and following my instructions again, including the extra steps I just posted. At this point I canât really help you unless you give me more specific details. Good luck!
This app looks amazing. I did have it working with the sample data, but in trying to configure it with the Foundation Template, I ran into issues. So I decided to delete the AppSheet App and start from the beginning. Now when I copy the AppSheet Template, it gives this error:
âThe TillerBudget-1438804 app did not load successfully. Please contact the app creator.
Unable to fetch app definition. App âb0a6a5f0-c7f5-4edb-a916-928a83e7d0f2â is not runnable â please contact the app creator.â
In the columns tab, itâs also reporting these issues:
"Column Name âElement_For_Related Transactionsâ in Schema âCategories_Schemaâ refers to ReferencedTableName âTransactionsâ. That Table or Slice uses RowNumber as a key which is not a stable key.
Column Name âElement_For_Related Budgetsâ in Schema âCategories_Schemaâ refers to ReferencedTableName âBudgetâ. That Table or Slice uses RowNumber as a key which is not a stable key.
Column Name âElement_For_Related Transactionsâ in Schema âAccounts_Schemaâ refers to ReferencedTableName âTransactionsâ. That Table or Slice uses RowNumber as a key which is not a stable key."
Any ideas on what might cause the app to not load?
1 Like
Got the same error when I tried to use it. I think the creator need to reprogram the app to use Foundation template.
I thought the same thing - but I get the same error even when copying the App and attempting to use the sample data or the budget template.
I was just about to come post with the same question/error. I created a brand new spreadsheet with the original Tiller envelope budget template, and got those same errors. It wonât let me include a screenshot because I just created an account for Tiller Community.
I have the same messageâŚ
I have adapted this solution to the foundation template.
I had to go thru and regenerate structure and save a few times on individual tables to get a few errors to go away.
The most cantankerous part of this was the âbudgetâ tab in the app. I pointed this to âmonthly budgetâ in the foundation template. This required that I rename several columns in the budget columnsâ set. To ID the correct column required using âView Dataâ and counting down the list. Call the âbadâ one ânameâ_OLD and then rename the good one to the old oneâs name. This leaves you with a column named [Rollover] that is vestigial. Several errors will crop up if you donât have a [Rollover] column, so youâll either need to address the errors or create an empty [rollover] column.
The âBudgetâ tab doesnât lay out the columns correctly even though the data look good. I donât see in Appsheet how to deal with the column width in the phone view.
I also got this working thanks to @jdees 's tip, but Iâm still playing around with it. I got stuck for the longest time on the error and the inability to properly regenerate the table with the proper columns.
@nikelle.dawn @christina.bennani - Appsheet doesnât seem to like the Insights Tab or the Monthly Budget tab in the Foundation Template. Iâm guessing itâs because of the merged cells at the top and itâs not able to read the column headers. I was able to get rid of the error when creating a new sheet and referencing the Monthly Budget tab starting at line 14
@jdees - to adjust columns on the Budget phone view, try UX -> Views Tab -> Filtered Categories -> View Options
1 Like
Iâm not using the foundation template, Iâm using the original Tiller Budget template, as listed at the beginning of the post by @richardpeng . Were you only able to find a solution for the Foundation Template?
Iâm getting the same errors you listed:
Column Name âElement_For_Related Transactionsâ in Schema âAccounts_Schemaâ refers to ReferencedTableName âTransactionsâ. That Table or Slice uses RowNumber as a key which is not a stable key.MORE INFO
and this one twice:
Column Name âElement_For_Related Transactionsâ in Schema âCategories_Schemaâ refers to ReferencedTableName âTransactionsâ. That Table or Slice uses RowNumber as a key which is not a stable key.MORE INFO
Iâm thinking you may need to regenerate the structure of the Accounts and Categories tables.
Thanks for the tipâŚhad to go into ârev viewsâ under âviewsâ rather than âprimary viewsâ to get the columns right. Scrolled down farther than I thought I would have needed.
As @richardpeng notes aboveâŚthe rownumber as key should be a warning not an error.
I was getting rownumber as key as a hard error that was preventing the app from working on and off yesterday when I worked on the foundation template. I have no idea what fixed it other than regenerating the table structures a few times.
We could fix this if there were a key row in the Tiller transactions list that was applied to any transactions. The CSV importer doesnât appear to assign a unique key to added transactions, and I guess that would be the case for manual transactions either. Perhaps that needs to be a feature request - adding Tiller transaction IDs to manual and CSV imported transactions.
1 Like
So, I ended up creating a separate spreadsheet which I called âAppsheet Feedâ in my Google drive. I used the IMPORTRANGE function to pull in the info I wanted from the Foundation Templateâs Monthly Budget Sheet, which was cells (A14:H200). That got me the real info I needed and bypassed the top of that sheet which tripped up the Appsheet table generation. Also, it allowed me to avoid having another sheet clog up my Tiller Template.
Since the Foundation Template Budget didnât use the rollover concept and I wanted a YTD available amount, I also installed the Yearly Budget sheet from Tiller Labs and ported that into my Appsheet Feed as well. Then I setup a virtual column in Appsheet which calculates the YTD available from the YTD Budget and Actual columns. Now when I drill down in a transaction in the phone appâs Budget feature, it shows the monthly budgeted amount, the amount spent, the amount remaining and the YTD amount remaining which is just what I was looking for. Thanks to @richardpeng for a very cool app and all the help!
1 Like
I see, so how do you regenerate the table? Is it just the Regenerate Structure button I see? And did you do it for each column, or just the Categories and Accounts columns, since those are generating the errors?
@nikelle.dawn Yes, the regenerate structure button is way to do it. I probably ended up doing it for every table at one point (Categories, Accounts, Transactions, etc.)
If I categorize an uncategorized transaction through Appsheet, it creates a duplicate entry, instead of overwriting the original. Does anyone know a workaround to this? I tried defining the Transaction key with the [Transaction ID] column data instead of _RowNumber but that did not seem to make a difference.
Silly me - I was using the wrong button. In the transactions details, there are two icons. The two sheets of paper icon adds a transaction prepopulated with information from the transaction you are looking at. The pencil and paper icon allows you to edit the transaction youâre looking at. Oops!
@jdees I cleared the rownumber as key error by unselecting that as the key in the Transactions table. Instead, I turned on Transaction ID with Initial Value = UNIQUEID() and that seems to work. This removed all the manually-entered transactions I had imported from Quicken (as it would for items brought in through the CSV importer, as you mention). I used the script RANDALPHA someone wrote to generate a 24-digit lowercase alphanumeric unique ID for the ~900 IDs I needed and pasted those in and that brought everything back into AppSheet. I think you could put any number in the Transaction ID field so as long as it was not NULL, but generating a unique ID seemed way nerdlier and awesome.
This might work better since you are in a separate tab already. I couldnât find any documentation that assigning a key to manual transactions in the official tiller tab would confuse something or other on the Tiller side.
At some point I will probably try to pull in to a separate sheet as that seems much more robust than relying on the formatted results.
Also putting the structured data in explicit tabs rather than hiding to the right in the monthly budget would be a good way to improve the structure of the tiller foundation sheet.
has anyone found a modern version of this which will work with the new Tiller Savings Budget, since the Tiller Budget Template is obsolete?
I would love it if someone could help me with adapting this to the Savings Budget or the Foundation Template. I tried to adapt it but I am not adept enough with AppSheet.
1 Like