How to add a customer survey feedback

[enkeli]

I need to add to my desktop app a customer survey for satisfaction, where they can press buttons if they were happy or sad, and answer to a simply question. I want all of this data saved into a database. How can I make all of that happen?

Thank you in advance!

Angie

[Michael]

To write text to a file use the action “Project > Save text to file” when the button is clicked. The file is saved in the Documents folder.

See the attached project save_to_csv.pma (491.8 KB)

[enkeli]

It works like charm. But I have a new need: The costumer have to answer aq uestion, and that written answer must be saved in a file or emailed. Thanks in advance!

[Michael]

To save user text:

1. Add Form widget and select Text area in Type list in Form inspector
2. In the above example for text argument select Property in Type list, then select your text area in the Object list and Property > Form > text in the Property list

save_text.pma (491.1 KB)

To save multiple fields to a single line, i.e. user name and comment:

1. Select Script code in Type list
2. Paste the following code:
   document.childByName("Text area").content.text + ";" + document.childByName("Name").content.text
   where “Text area” and “Name” are Form widgets

save_multiple_fields.pma (529.7 KB)

[lorentz]

Here you explain how to add “text to file”, elsewhere there is an explanation about getting stuff from a DB, but is it also possible to INSERT form input in a connected DB? + call a script on a server which sends an email automatically.
If yes: what happens if anything goes wrong (f.e. bad internet or serverproblems).
If no: can we also save the file generated via “text to file” somewhere externally on a server. so we can run a script on that file?