https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


link to another table

  • ckolouas1
  • ckolouas1's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 7 months ago #2834

I would like to have multiple tables and link them together. They will have common columns, and pressing on a field, will point the user to another table giving more information for that field. Can you please help me out to do this. Maybe, if you can give me an example.

Thanks,
Constantine

Please Log in or Create an account to join the conversation.

More
8 years 7 months ago #2838

Hi,

for this you can use the Custom Link option and write a link that sets search parameter to another table. I suggest that you take a look at the following topics:

toolsjx.com/support/2-installation/2185-customizing-grid#2406
toolsjx.com/support/3-suggestions/1208-s...ment-provided-by-url
toolsjx.com/support/3-suggestions/1389-l...ble-field-to-1-table

Regards

Please Log in or Create an account to join the conversation.

  • ckolouas1
  • ckolouas1's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 7 months ago #2858

I managed to link it ti another table , however it does not automatically execute the search once the table is loaded. How can we make it so the can be displayed with automatically being executed with the search parameters?

custom id: index.php/[email protected]

Displays all the table and the search button has to pressed afterwords. I want to automatically display without me pressing the search button.


Thanks,
Constantine

Please Log in or Create an account to join the conversation.

More
8 years 7 months ago #2861

Search should work automatically. Apparently you have forgotten the s_f parameter, which sets the search field.

If "Advanced Filters" are NOT chosen:

www.url_to_table_B?aso=exact&s_f=searchfield&data_search=$ID

If the option "Advanced Filters" is checked then the link should be:
www.url_to_table_B?aso=exact&data_search=searchfield|$ID

where aso=exact reffers to "Advanced search option". Now it will perform exact search on idbonus. If you leave aso=exact out it wil perform normal search.


Regards,
Tomaž

Please Log in or Create an account to join the conversation.

  • ckolouas1
  • ckolouas1's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 7 months ago #2866

Not working...
I tried to also put s_f=datafield but does not give the results automatically. It puts in the value inside the search box but does not automatically execute. I tried with $ID instead but does not recognize the $ either.

I need some help or else this will not be useful for me.

Thanks,
Constantine

Please Log in or Create an account to join the conversation.

More
8 years 7 months ago #2869

Hi,

Do you have this somewhere online? If so, you can grant ma access to your website and I will check what goes wrong. You can sent login data to This email address is being protected from spambots. You need JavaScript enabled to view it.

Regards,
Tomaž

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.195 seconds

Contact Us

Contact us on Facebook