Hello Appsheet, I need help with referencing...

(Miranda Lubarsky) #1

Hello Appsheet,

I need help with referencing columns in another table.

I am trying to create some expressions that are like refs without being refs because I cannot having something as a label.

I have a column named [Plant ID] in another table.

It is the key of the table, but not the label.

I cannot change this.

Have tried to no avail.

It won’t be changed.

In my current table I also have a column named [Plant ID] and I am creating a drop-down menu by referencing the other table.

I used this in the Valid-if field which worked.

=Design Numbers for 2018[Plant ID]

So as I’m filling out this form, I select a plant in the Plant ID field/column.

All good there.

Now what I want to happen is for both the main planting dates and the price per plant to pop up automatically when the Plant ID is selected.

Thus far, I was successful with the First/Main Planting Date.

I used this equation in the Valid-If field:

=(Design Numbers for 2018[First/Main Planting Date, Week Of]).[Plant ID]

It works.

Now, when I try to do the same for the Price Per Plant column, it says “could not be parsed due to exception: Object reference not set to an instance of an object”

What does this mean?

Why is it not working?

So frustrated.

I feel like no matter what I do I keep having issues with creating stupid drop down menus.

I have tried several different things, saving & verifying which takes forever.

At my wits end with this thing.

You help is appreciated. Miranda

(Aleksi Alkio) #2

You could write that formula like… ANY(SELECT(Design Numbers for 2018[First/Main Planting Date, Week Of],[Plant ID]=[_THISROW].[Plant ID])) and then use the same structure for Price Per Plant.

(Miranda Lubarsky) #3

@Aleksi_Alkio thank yousomuch!!