Help Possible to create menu

Topic: Help Possible to create menu (Read 2417 times) previous topic - next topic

Help Possible to create menu

January 28, 2019, 08:13:35 AM

Hi
Congratulations for the software I'm testing and it's very good
You can confirm that it's possible to do what I want.

I share a picture to make it easier to explain.

When choosing ICT or programming or Functional or Wifi appear below the list of correct malfunctions. each of them have a different list.
Can you help?

Thank you

Re: Help Possible to create menu

Reply #1 – January 28, 2019, 12:11:13 PM

With the actual tools of PHPRad you can do that with linked Select fields, so when you select 1st option, in the 2nd you only see the relevant fields to the 1st selection.

If you want to change it from Select to some other field type, you have to do it manually in the code

Re: Help Possible to create menu

Reply #2 – January 28, 2019, 12:24:21 PM

Thank you for your help.
I'm not comfortable programming it yet.
I'm starting
Can you help me with some simpler example?
Thank you

Re: Help Possible to create menu

Reply #3 – January 28, 2019, 03:33:53 PM

If you mean an example of changing the "look" of the fields, that is not something that can be explained easily with just an example, because it would involve finding the right Vue libraries for the type of fields you want, loading them to the project page, etc etc.. and of course, a bit of testing and carefully not altering existing code.

If you mean how to do a linked select field, go to the ADD page, change the field type that will store the primary value to Select (but i guess you can use radio too) and define the proper OptionListDatasource (in your case it should be Tipo Teste.. then select the field that will store the Tipo Avaria and procced the same way, but there you have an additional option to check in the query selection "Dynamic Select Lookup" where you select the field to match both tables.

Re: Help Possible to create menu

Reply #4 – January 29, 2019, 07:07:53 AM

I was able to enter in a way to select in (Test type) and at the bottom the wheel to update the list of choices appears.
Now I still can not figure out how I put the options to appear.
after configuring the Data Table where the "Dynamic Select Lookup" is set, I have to configure the batte below.
can help?

Thank you

Re: Help Possible to create menu

Reply #5 – January 29, 2019, 04:16:38 PM

Sorry, I don't understand the question.

Re: Help Possible to create menu

Reply #6 – January 29, 2019, 06:19:12 PM

I still can not make it work.
I'm using "Dynamic Select Lookup" but I still can not figure out how I have to do it.

thank you

Re: Help Possible to create menu

Reply #7 – January 30, 2019, 02:00:08 PM

I'll send another example of what I intend.
I may have explained wrongly.

When selecting "Test Type" the table of choice "Type Failure" changes the choices.

Thank you

Re: Help Possible to create menu

Reply #8 – January 30, 2019, 03:27:42 PM

Dynamic select lookup looks really well in phprad, but, of course you first need to know the logic behind what's a dynamic select lookup. The way most dynamic select works is by using 2 (or more) select fields. So, according to your drawing, it seems you are using a button that you expect to trigger changes in a select field.. is that right? I assume that can be done, but the easiest way to do it is with linked select fields. So in the first one you select the parent option, and the second will show the child options that depend on that parent.

Also, would help if you can provide the mysql structure you are using for the linked tables,

Re: Help Possible to create menu

Reply #9 – January 30, 2019, 06:21:39 PM

Hi,
"So, according to your drawing, it seems you are using a button that you expect to trigger changes in a select field.. is that right?"
Yes, that's what I mean.

I understood what I said but applied in practice I do not know how to do it.

Sorry, I'm starting I still can not figure out a few things.
I'm trying to recreate examples to later apply.
Thank you for your support

Re: Help Possible to create menu

Reply #10 – January 30, 2019, 06:51:54 PM

Since you have a single table and it's best to have 2 tables for what you want to accomplish, the only way to do what you want to do is by custom coding your own solution. As you have both fields in the same table, there is not real way to link them using primary keys because they share the same.

Maybe you should learn a bit about how databases work and the logic in creating tables and fields before venturing into creating apps. RADs are great tools, but are not magical wands that spit custom code.

I haven't tested if a button can trigger a select, probably, but not sure if that can be done without custom code (again)

Re: Help Possible to create menu

Reply #11 – January 31, 2019, 10:35:30 AM

Hi, thanks for the tip. I'll change. I am already reading MySQL manuals. I will change and separate the tables. Thank you for your help.

Re: Help Possible to create menu

Reply #12 – January 31, 2019, 02:00:37 PM

can explain how "Query Builder" works after filling in the "Data Table" I am directed to Query Builder.
To be able to interact with the various tables.

Can you explain how this part works?
Thank you

Re: Help Possible to create menu

Reply #13 – February 04, 2019, 07:35:27 AM

Hello,
I still can not create what I wanted.
will it be possible to create a small simple example?
Thank you

Re: Help Possible to create menu

Reply #14 – April 18, 2019, 12:21:51 PM

@LipzyLipzy check out PhpRad docs to understand more.