Hi,
I have a table with rent items. There is a single select field “availability” with “available” and “rent”.
Right now i set the “availability” manually if a new linked record “customer” has rent an item.
Now I want to automate the things :slightly_smiling_face:
As soon as I choose a customer from a list, the single select field “availability” should switch automatically to “rent”.
This doesn´t work…
IF(Customer = BLANK(), {Availability}=“available”, {Availability}=“rent”)
Can someone please help me out?
Thanks