Skip to main content

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 🙂

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

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.

Reply


Terms & Conditions