email notifications

[Anonymous]

Hello

Is there a way to pull the data from an email notification and insert it into a form instance mult-line text box?

If you don’t know if it’s possible, can you point me in the direction of how email notification are generated and stored in mysql.

[Dennis @ PerfectFormsBlocked]

All of the data for a notification is in the instance. If you want a notification replicated in an instance the best thing to do would be to use a set field with a formula that reproduces the notification. We do not support pulling information straight from the PerfectForms database.

[Anonymous]

Thanks this will work. Is there a function that will allow a “return” or “indent” to the formula?

Example

first name

+

” ” (space)

+

last name

+

” ” (space)

indent or return

+

Comments:

So the notification would look like this in a multi-line text box.

John Doe

Comments: hello world

[Dennis @ PerfectFormsBlocked]

There is no “return” or “indent” function. Because it is dynamic, there is not way to know exactly how many spaces you need to add. I usually just make my best guess on the number of spaces.

Workflow software, Process software, Procedure software

[pmeidingerParticipant]

Here’s how I handle adding a newline/return to a multi-line text input:

• Crete a sedond, hidden multi-line text input field, call it “Return Text Input” or something

• In the text for this input, just hit the Return key

Now in your formula you can do

first name

+

” “

last name

+

Return Text Input

This way you won’t have to try to rely on spaces to get a newline in your multi-line text inputs.

[Anonymous]

I like it. Good idea! Thanks

[pmeidingerParticipant]

Glad you like it. I’m also glad you could understand my post with all those misspellings. Yikes!

[Author]

Posts