Help with Constraining Addresses

Need help
1

I’d like to do a calculation on the round trip miles for an address selected from a dropdown to calculate the expense amount.

I’m running into trouble with the address constraint.
I need to find the address that was chosen from the dropdown in my data and then get its round trip miles.

I was able to get a result using :first item thinking that my constraint would yield a list with one item and then the first item is the only item.

But the result was incorrect leading me to think that my constraint isn’t working.

Any suggestions?

1
1.png1714×1064 172 KB

2
2.png1712×1094 171 KB

2

Your non-working version seems restrictive. It may not be finding any results or it could be a data type issue. What step calculates the round trip miles?
Let me know if you want some help with it: https://calendly.com/slickrock-15/15min

3

This topic was automatically closed after 70 days. New replies are no longer allowed.