About DaGi07

DaGi07 · 01-04-2023

Hello guys,i'd like to sum the value "importo" from the table "spese" of current month BUT until yesterdayexample:Date Importo01/01/2023. 302/01/2023 303/01/2023 204/01/2023. 5Result: 8 because is the sum from 01/01/2023 to 03/01/2023How can i integr...

DaGi07 · 01-03-2023

Hello guys,i'm trying to build a money saving app.I'd like to set a daily spending limit based on an amount I'd like to save per month.So far easy.In a few words, I'd like to move the savings from the previous day to the next dayI'll explain better w...

DaGi07 · 12-30-2022

Hello guys,I would like find an expression that give me the number of days until the end of the current monthExample (today 28 december, result--> 3 days to the end of december)

DaGi07 · 11-15-2022

Hi guys, how can i avoid this errors? The column [Koros] is type yes/no and i would ectract the result from table CERCA_ODOO. If the koros field is yes, then I want to do one thing, otherwise another. I tried with ANY() but it doesn't works. Tks guys

DaGi07 · 10-12-2022

Hello guys,I am creating a dashboard with a search filter. I created a virtual column "final balance" that has this expression: SUM ( SELECT (ESTBC [taxable invoice], [Paid] = SEARCH [Paid]))Where the [Paid] field from the SEARCH table is of type Enu...

DaGi07 · 01-04-2023

@Suvrutt_Gurjar thanks to you finally i completed the formula that consent to create a daily saving according to the monthly amount that you want save!I post here the expression that consent to do this in case could be useful for someone else

DaGi07 · 01-04-2023

I noticed that the formula in spreadsheet can be simplified like this but i dont' manage to transform this in appsheet expression..

DaGi07 · 11-15-2022

@1minManager Column Koros: The column where i set this expression is type "percent" because i have to obatin numeric value introducing other math expression but these compute must change IF Koros is true or false...

DaGi07 · 11-10-2022

@Steve you are so precious!! Can you explain me the role of ("" & in this expression?Thanks!! 

DaGi07 · 10-19-2022

@SkrOYC @Steve i made this correction but it doesn't works IN([Paid],SPLIT(SEARCH[Paid],",")))I tried also with[Paid]=IN(SEARCH[Paid], {"paid", "unpaid", "paid , unpaid"}) Could you help me? tks

My Stats

authorspirit's Bio

Badges DaGi07 Earned

Recent Activity

SUM expenses current month until yesterday

expression to make daily spent limit based on previous expenses

number of days until the end of the current month

error: cannot compare list with Yes/no

Search filter with EnumList type

Re: SUM expenses current month until yesterday

Re: expression to make daily spent limit based on previous expenses

Re: error: cannot compare list with Yes/no

Re: Search filter with EnumList type

Re: Search filter with EnumList type