How to query an Assets Status in a design form

How to query an Assets Status in a design form

I am trying to create a service catalog for equipment loaning. I would like the user to be able to choose from a list of items and when chosen SD to check status of the item and if it is available to assign the asset to that user, if not to return a message etc

Is this possible? 

                  New to ADSelfService Plus?