This is very valuable for anyone trying to make this app work. This should be a permanent fix in the next iteration. LOOK HERE AND ABOVE. @richardpeng
Hi @richardpeng ! I find your app really valuable and convenient. Iâve been using it for a couple months without a hitch but suddenly, today Iâve been getting the error:
âUnable to fetch app definition. Error: There is a mismatch in the number of columns between the spreadsheet for Transactions and the table schema. The table has 19 columns but the schema has 18 columns. Please regenerate the table column structure. Error: Data table âTillerFoundationBudget-6522895-22-11-14:1.000006:Transactionsâ is not available Error: The data for this view cannot be found. Please select a new data table in the view settings.â
I tried recreating the app again to see if it will solve the problem but I kept getting the same error. I noticed that the date in the âGrant accessâ cell of the Tiller AppSheet Lookup Sheet shows the date two days ago (11/10/2022). Iâm not sure if thatâs what causing the problem. I hope you can help me! Thank you!
I think I have fixed it. I just need to delete an extra blank column. Thanks!
I think the error is also saying the column structure on the Transaction Sheet has changed. Probably the extra column. You can also fix this by going to the correct Data Table - Click Columns - and Click the Regenerate Structure.
This was released by a community member over two years ago, so itâs possible the author isnât frequenting this forum any more.
Thank you for responding. I deleted my long posts elaborating errors that I thought were caused by the app or instructions, but were embarrassingly my own end user error. It âjust worksâ again for me now.
1 Like
When I split transactions, several columns in the newly created entries contain the value =âCOMPUTED_VALUEâ. Does anyone have any suggestions on how to fix this?
