Sep 05, 2024 03:17 AM
I have 2 datafields, room type (single room & double room) and guests (1 to 2 names)
if in singleroom and the guest (the volume is 1) should say "occupied" in the formulafield and
if in room type (double room) it says and guest (the volume 2) then “Occupied” should also appear in the formula field
MyCode:
IF(AND(room type = "double room", {client overview} = VALUE(2), room type = "single room", {client overview} = VALUE(1)), "occupied")
Sep 05, 2024 06:10 AM
What field type is your Client Overview field? Would you please provide a screenshot?
Best,
Mike, Consultant @ Automatic Nation
Sep 05, 2024 07:04 AM
Does this look right?
IF(
AND(
{Room Type} = "Double room",
{Count (Client overview)} = 2
),
"Occupied"
) &
IF(
AND(
{Room Type} = "Single room",
{Count (Client overview)} = 1
),
"Occupied"
)
Sep 05, 2024 10:35 PM
Yes, that's exactly how I imagined it. I thought about it for ages. thank you very much for the help.