Suggest Values - Showing Blank

Hey All,

I am trying to achieve a result using an Suggested_Values Request, to make a drop down menu to display only my [part_serials] that have these conditions [part_condition] = “GOOD” & [part_location_email] = USEREMAIL(). When I try to do this it just shows the dropdown as blank, I still need the user to be able to add their own serial if needed.

This is what I’m trying to do ATM:
SELECT(parts_index[part_serial], [part_condition] = “GOOD”, [part_location_email] = USEREMAIL()).

Supporting Photos

image

All help is much appriacted.

Thanks,
Nick.

You forgot to put AND() statement inside your formula. It should be

SELECT(
	parts_index[part_serial], 
	AND(
		[part_condition] = “GOOD”, 
		[part_location_email] = USEREMAIL()
	)
)
1 Like

Thanks June,

That did allow the expression to register correctly, i am still not seeing any of the [part_serial] in the list it will just display it as blank. Am i using the formula in the correct location?

From Expression Assistant, where you enter your expression, use the Test button to test your expression. You can see what results it will produce without having to save your changes and try from the app.

Please also post a screenshot of your current expression, and a screenshot of the part_serial column configuration screen.

1 Like

Hey Steve,

Ahh yup that makes more sense to try and produce a result rather then going back and forward. Hopefully this is what you are asking for.




1 Like

image

Hey Steve,

Ahh yup I see so this is the result it shows for me.

Just to confirm also these are the two tables i’m working with, [parts_ref_index] has a Ref to my main table with all my jobs which is [job_index]


For some reason this will work with every other table i have in an spreadsheet it just does not want to work with my [parts_index] in not sure if this helps as an example.

1 Like

Issue has been resolved, it was on my end not Regenerate Structure. Thanks for you help June_corpuz

2 Likes