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
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.
@Aleksi_Alkio thank yousomuch!!
Translate
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |