Dynamic data on web site tables
Add web site widgets that will take dynamic data from the member database and allow you to format it into tables on the web site.
Robin Sapiro commented
What you really want is the ability to just use the same macros that we can already use in an email to be used in a web page.
By default it would display this data from the currently signed on member, but it could also as configured by the site builder also display data from a specific member (select by member number) or from all members that meet specific search criteria as defined in a saved search.
Email editor should also be enhanced to present data from these additional IDs.
Another alternative would be to have the ability to embed a .TXT or .HTML file into an email or web page in the same way that a JPG or PNG etc can be done at the moment - ie resolve the content rather than just linking to it
Daniel Frankel commented
I have added several fields that I maintain in the member tables. It would be nice to be able to run a report that I can put on the web site for all to see of this data specifically. Our candle report is an example. At this point, I manually extract the data, put it into an excel spread sheet, and then put the spreadsheet in a widget on the web site. I'd like to be able to skip all the manual steps by setting up a widget on the web site that pulls the data from the member database in real time. Here is an example of one of my screens that should be directly pulling data from the member database:
First name Last name # Candles Previously Lit Candle 1 Candle 2 Candle 3 Candle 4 Candle 5 Candle 6 Candle 7
Michael Bernstein 3 11/17/11
Sid Besmertnik 3 11/10/16 12/08/16 05/11/17
Jeffrey Budd 4 02/09/17 03/17/17 04/20/17 05/11/17
Issy Cheskes 2 06/11/15
Paul Flexner 3 02/09/17 03/17/17 04/20/17
Mitch Frank 4 08/26/15 02/09/17
Anthony Gold 1 05/08/14
Stuart Green 05/08/14
David Hummel 6 11/10/16 12/08/16 01/12/17 02/09/17 03/16/17 05/11/17
Andrew Jacober 3 11/10/16 12/08/16 02/10/17
Douglas Katz 5 03/10/16 12/08/16 01/12/16
Joel Lesser 1 02/09/17
Michael Londe 3 12/06/12
Alexander Malenky 2 03/10/16
Randy Pores 2 11/10/16 01/02/17 03/16/17
Howard Robins 1 08/28/14
Michael Schulman 2 06/18/15
Joe Stich 3 09/07/14
Michael Terushkin 1 06/11/15
Adam Throne 2 02/09/17 04/20/17
Steven Zedeck 6 11/10/16 12/08/16 01/12/17 02/09/17 03/16/17 05/11/17
Robert Zimmerman 5 02/09/17
AdminEvgeny Zaritovskiy (VP Technology of Wild Apricot by Personify, Wild Apricot by Personify) commented
Could you elaborate? An example maybe? What is the problem you're trying to solve?