Further to my database problem ..... Here i...

(Mary Jane Pender) #1

Further to my database problem …

Here is what I tried to do: 1)

Used column B in sheet 1 to ref that column in sheet 2. - worked

Used column B as a deref in sheet 1 to pull in values from sheet 2 - worked

Requested to filter the contents of column B in sheet 1 by Category.

Added a Category column to sheet 1 just before column B in the spreadsheet.

I did this and it worked beautifully.

HOWEVER … the deref’s no longer worked.

Was I putting too much on the Column B?

(Aleksi Alkio) #2

Did you use the key column in your SELECT expression?

(Mary Jane Pender) #3

Hi Aleksi, to filter the contents of column B I did a column constraint

Valid If - and just the dependent dropdowns = sheet2[category] in the Category column and

sheet2[column B] in the column B Valid If.

User

clicks on Category and gets a filtered Column B list.

No

Select.

(Mary Jane Pender) #4

so… Sheet 1 Column B has a ref, a column constraint for dropdowns and an app formula for a deref.

Am I correct that it can’t have all 3 at the same time?

the deref seems not to engage once I added the column constraints.

(Mary Jane Pender) #5

Could someone tell me if having all three ref, deref and column constraint on the same column is a problem?

(Aleksi Alkio) #6

You can’t have all of them at the same time. You can use a ref field with Valid_If and deref if it’s on the initial value.

(Mary Jane Pender) #7

Thanks Aleksi.

You just confirmed my findings.

appreciate the help as always.

m.j.

(Mary Jane Pender) #8

Hi Aleksi , just to let you know, your question earlier about a SELECT expression got me thinking … so I

replaced the de-refs from 2 columns and used SELECT expressions in Valid IF to pull in the data from the from table in Sheet 2 .

Client gets all the functionality they requested.

Thank you.

m.j.