This is the data I work with I want to have a dependent drop down menu
First “Block”
Then “Unit”
Then if Availability = “Yes”
Show “GLA”
And “Rate”
and i want to do calculation like
Rent = GLA*Rate
and so on
Then if Availability = “No”
Just show message " The property not Available"
and do not show any calculation
When creating the system, you can work with auxiliary tables, which you can use to create separate drop-down categories.
The moment you want to display your list filtered according to the selection, you have to set the filters of the table displayed on the page to be variable, i.e. using user-specific fields.
In the event that your selection contains no hits, nothing would simply be displayed. Of course you could display corresponding information for the user - but in your case I would first focus on the structure in the background.
My tip: Take some time and watch the various tutorials at the university and/or on YouTube.
thank you for replying .
I watched a large number of videos on YouTube and was able to create a drop-down list from the two fields ( Block and Unit ).
My problem is executing the condition and showing the correct data.
Note that I only use the free version because I cannot purchase the paid version now
Ok, in this case the second dropdown should contain a filtered view that only shows the units that are assigned to the corresponding block.
This means there should be a “Blocks” column in the “Units” table. The selection of units is then filtered to this column.
I’m Real New to This, Can someone Guide me through it
This is what i did I’m Not sure if it’s accurate
The problem is how to show Other data related to that field only
In the second component you should be able to set a filter using options so that only the units that match the first selection are displayed.
This doesn’t help. I asked for help because I don’t know how to implement it.
I need someone to guide me through it
No issue,
write me a direct message.
I can do that for you.
Thanks man .
I will do so and send you a direct message
