About Fael

Fael · 10-11-2022

Hi,I have a bot that is triggered when a new row is added. I need to use a column from this row to calculate a column from another row of another sheet using the bot. How can I access the column value from the event row?I was expecting something like...

Fael · 05-06-2022

Hi,I did an automation with Google Apps Script integration. When I go to the "test" option and try to run any task I receive the following error:"Failed: Apps Script project was not allowlisted for app owner with id=xxx. Apps Script must be added as ...

Fael · 05-11-2023

Please refer to:Create and save a file from an automation - AppSheet Help Archive files created from a bot - AppSheet Help

Fael · 05-10-2023

Hi,You don't need to filter twice. If you want the sum [TOTAL QTY], then you need to change the virtual column:SUM(SELECT( Photos[TOTAL PHOTO], AND( [channel] = [_THISROW].[channel], COUNT(INTERSECT([team name], [_THISROW].[team name]))>0, [DATE] = T...

Fael · 05-09-2023

@Sirfyaad wrote:Is this template expression of correct. Because I am using this expression in the template. Well, it is not. You need to show the [DataPerformChannel ] virtual column we created. Use it instead:<><<[DataPerformChannel]>><>

Fael · 05-08-2023

@Sirfyaad wrote: Group sum in template is not happening. Are you using my expression in your slice and virtual column? The result is the same as the above? Nothing changes?

Fael · 05-08-2023

Could you show me what is happening? The same way you did on your first post. Eg:

My Stats

Fael's Bio

Badges Fael Earned

Recent Activity

Bot: how to get the "Event" row data?

Error trying to use Apps Script integration: "Apps Script project was not allowlisted for app owner"

Re: Grouping Issue

Re: Grouping Issue

Re: Grouping Issue

Re: Grouping Issue

Re: Grouping Issue