Forums

I have form after submitting it creates in database an entry ...
Is there a shortcode that I can put into post, module, etc. to get back some values to frontend?

fe. how many people have subbmitted, how many vegetarians, how many .... to get back special values from columns ?

2. is there a extention that alows you to edit the database imputs ?
3. backend interface
imagine !!! that you have 256 entries and 10 you gave a give back result shortcode so on forntend it shows that 250max can register and than 15people cancel their registration and you have to delete them from database according to lower the value that is displayed on frontend🙂
dl.CVS search, search entried numbers, find them in list, delete🙂 would be lot easier if in CONTACTform fould be in vizard a field check to show result in backend than oyu can select wich values would be shown in backend directly !!! not needed to dovlnload CSV each time😉

frontend could look like {id form, id database, column number ,A makes a sum of values,B pick bigest, Cpick lowest,Dmakes an everidge1,2,4,6,12->5, D !! makes a list: if this is a taxt imput box it list all entried in this column: entry1,enty2,....}

is there something like this

Hi kjub6,

1) There is no shortcode to get data back from a database table. But you can easily add MySQL queries into a Custom Code action to get any values that you need.

2) For occasional edits you could use PHPMyAdmin or a similar tool; or the AceSQL extension in your site Admin. If you need more frequent edits then I usually set up either a ChronoForm using the DB Multi-Record Loader or a ChronoConnectivity listing. Either of these will let you create a list that you can filter. I then create an edit form that is linked to each entry in the listing.

3) See 2 above.

Bob