The app would not run and told users to contact the developer,.
Extensive troubleshooting found a space had been added to similar expressions for 6 virtual columns. Here is the error:
Column Name โPTO Usedโ in Schema โEmployees_Schemaโ of Column Type โDecimalโ has an invalid app formula โ=SUM(SELECT( TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[ EmployeeID],[Task]=โPTOโ ) ))โ. Error in expression โ[_THISROW-1].[EmployeeID].[ EmployeeID]โ : Unable to find column โ EmployeeIDโ
Looking at Copy26Sep2020 test version of TT Admin, it is running without errors.
PTO Used (Decimal)
SUM(SELECT(TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[EmployeeID],[Task]=โPTOโ ) ))
Prod is
SUM(SELECT( TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[ EmployeeID],[Task]=โPTOโ ) ))
Note there is a space infront of the E. This is the case in all 6 virtual columns. I fixed all of these and we are good!!
What are you looking for from the community?
This appears to be a bug. How did the spaces get added?
Good question. You should probably engage support@appsheet.com for help with this.
Thanks Steve. I submitted to support.appsheet.com today,
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |