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")
What field type is your Client Overview field? Would you please provide a screenshot?
Best,
Mike, Consultant @ Automatic Nation
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"
)
Yes, that's exactly how I imagined it. I thought about it for ages. thank you very much for the help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.