I thought I would be able to nail this, but I can’t…
So in a Task Management app, a Project has many Objects, and an Object has many Tasks
(the project would be to make the furniture of a coworking, and an object would be to make a table, and a task would be to make the desk of the table).
There is a Projects Table with a Project Name column
There is an Objects table, with an Object Name column and a Project Column that references the Project Name column from the Projects Table.
There is a Tasks Table, With a Task Name column, a Project column that references the Project Name column from the Projects Table and of course, an Object Column that the Object Name column from the Object Table.
So, I create:
- Object 1
- Object 2
- Object 3
- Object 4
What I can’t figure out how to do, is that When I create a New Task, after selecting the Project to which it relates, in the dropdown for the Object to which it can relate, I get all the Objects already created.
What I am trying is to get only the Objects that refer to the Project already selected in the question above…and I can’t figure it out…it’s a dependent dropdown but the Video I found as tutorial from @MultiTech_Visions is somewhat a different situation as all the data is in one Table:
Dependent Dropdown Video
[https://help.appsheet.com/en/articles/961554-dependent-dropdown](http://Dependent Dropdown article Written by Santiago Uribe Montoya)
The irony, is that there is the automated Virtual Column made in Projects, with Lists of Related Objects and is basically exactly what I need to show up in the selecting the Object question of the Form, but I can’t put it in the Form, I can’t duplicate it because I can’t make a list column … I tried a bunch of things but they didn’t work…
I’m guessing that in the Object Column from the Task Table, which is a reference to the Object Table, there should be a formula for the Valid If field.
Thank you so much,