Skip to main content
Participating Frequently
February 21, 2023
Question

Table driven by dropdown options

  • February 21, 2023
  • 3 replies
  • 649 views

Hi everyone! I'm trying to display a list of options to the user depending on which option they select from a dropdown list. 

Ideally, this displayed list is editable by the user (like if they want to update the phone number). The final goal is for the user to be able to submit his selections/edits so that an admin receives this via email. See attached mock-up of what I have in mind. I'm not sure how to tackle this and would appreciate a nudge in the right direction. Thank you for your help in advance!

This topic has been closed for replies.

3 replies

Legend
February 22, 2023

My initial thoughts would be is this even viable without a lot of extra thinking. You would need to ensure your table of data is responsive to adapt to the max width of email clients which is typically 600px wide.

 

You then somehow have to clone the whole table of data so you can assign it to some kind of server script which can handle html to send it by email.

 

Realistically you are probably looking at a database driven solution to store the information which can be called  by specific  'region' or 'group'. Then updated by those users who are given permission to do so then pass the updated data back into the database at which point you can call the data again and build an html compatible email. 

 

Quite involved, but certainly possible for a skilled coder, if you take all considerations into account

 

 

Liam Dilley
Inspiring
February 24, 2023

Forming the data options etc on the front end VS what is in the email are different things so the considerations are different. 
I do not think this is that involved either, I would be giving this to one of my Junior Dev's to do.

Legend
February 24, 2023
quote

Forming the data options etc on the front end VS what is in the email are different things so the considerations are different. 
I do not think this is that involved either, I would be giving this to one of my Junior Dev's to do.


By @Liam Dilley

 

A dev at any level should have already attained a  certain level of skill to be employed. If youre coming at it with very little knowledge or you're not a dev then it's going to be problematical.

Liam Dilley
Inspiring
February 22, 2023

How you get the data in a table will be initially important but one of the amazing things out there you can use at the moment is DataTables: https://datatables.net/
Still runs of jQuery but does have stand alone versions as well these days.
It is a great dynamic front end way to get content, filter it, search it and manipulate the data tables. It has full support for filter dropdowns like you need.
Otherwise you would look to render a list and do more server side solution (Depending on the platform/hosting and languages you have/using) with POST request on an option and displaying results or similar and Ajax requests.

BenPleysier
Community Expert
Community Expert
February 21, 2023

Something like this?

https://youtu.be/zAaduTP_VQk

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!