Conditional linked record with single select

[Yosh]

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

[Zollie]

Single selects don’t have default values - so you won’t get that field pre-populated unfortunately. Your best alternative is using it in conjunction with a formula field (similar to what you’ve written).

But before I get to that, this part of your description is confusing:

if a new linked record “customer” has rent an item

Not sure how you’re using Customer (if it matters to the formula, what the data looks like when a customer rents an item). It’s tough to build an example without seeing your table. But ignoring the customer bit, you can do something like this:

Availability Controls (Single Select)
BLANK
Available
Rented

Availability Status (Formula)
Available
Available
Rented

Formula
IF({Availability Controls}=BLANK(),“Available”,{Availability Controls})

Formatted for Readability (this won’t run)

IF(
	{Availability Controls}=BLANK(),
	“Available”,
	{Availability Controls}
)

Explained

If ‘Availability Controls’ is left blank, display “Available.” Otherwise just display whatever is in the ‘Availability Controls’ field.