This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi!How to do..Ihave table with "client_preferences", there is columns -
"Client" (text), "Preferences" list of values [red , blue , green]I need
to get list of Clients who prefer red or blue. Some Clients have all
this values.I need the list where if...
Why I cant to write so to compare 2 values? Expression result here is
YES/NO I think:MONTH(orders[order_date]) & YEAR(orders[order_date]) =
MONTH(TODAY()) & YEAR(TODAY())but it is right:
MONTH(TODAY())&YEAR(TODAY()) = 32022
Maybe architecture of data may be better?In AppSheet for calculations
its necessary to add vrtual columns. But it is not good way I think. So
In different tables count of virtual columns will be more and more. And
It wil be complexly to understand wh...
I have 2 tables - Clients (100 people) and Orders. Clients sometimes
order Flowers.The tables are already linked and have the following
structure:- Clients (clientUID, name).- Orders (orderUID, clientUID,
goodsIndex, sum).I need the whole list of my ...
It can be good compared as text, and it works:IF( IN("*",
SELECT(orders[price],AND([hUID] =
[_THISROW].[hUID],text([order_date])&year([order_date])) =
text(MONTH(TODAY())&YEAR(TODAY()))))), "1", "")---- But I looking for
any formula to compare month ...
There is a problem here.IF( IN("Flowers", SELECT(Orders[goodsindex],
AND([clientUID] = [_THISROW].[clientUID], [OrderDate] >= TODAY() -
90))), "ok", "") Orders will be shown not for 3 months, but for 90 days.
That is, if today is 01/15/2022 And if we...
mm.. but this expression shows all orders include orders from last all
years when month number = month(now).. But I need only this month
orders. I tryed concatenation above
Excuse me, but if necessary to show only This month orders?There must be
any like: month([OrderDate]) & "." & year([OrderDate]) = month(now) &
"." & year(now) ?But if I try:IF( IN("Flowers",
SELECT(Orders[goodsindex], AND([clientUID] = [_THISROW].[cl...
