checking data from different files?

13 views
Skip to first unread message

Inge

unread,
Oct 31, 2025, 8:59:23 AM (11 days ago) Oct 31
to NV Form Mule Add-on
Hi, I am working with a two step registration. So participants fill in one form and get automated emails. Then they get a second form for details of their registration. No when the results come back in two different files, is there any way to check data in the first file? Like if person A sends in form 2, can there be a automatic colour or text in responses to form 1?  I need somehow to see who has also turned in form 2. 
 I made 2 different response files,  maybe I need to start with having both forms respond to the same file, different sheet? Can two sheets have different setups for emailresponses? 

Thanks!  

Joseph Schmidt

unread,
Oct 31, 2025, 9:49:32 AM (11 days ago) Oct 31
to nv-form-m...@googlegroups.com

There are pros and cons to having responses from two forms in the same spreadsheet.

I have not experimented with multiple forms feeding into one spreadsheet.  I don't think you can setup Formmule to process from two different sheets.

The separate spreadsheet method has been used by many folks.



--
You received this message because you are subscribed to the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-mule-ad...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-form-mule-add-on/27db76d5-d563-453c-9c78-16a2e5bba8a6n%40googlegroups.com.

Inge

unread,
Nov 10, 2025, 4:53:50 PM (18 hours ago) Nov 10
to NV Form Mule Add-on
Thanx!
I've decided to just go with 2 forms and 2 response sheets. But I have a problem sending link in auto mail to form 2. It doesn't show as a clickable link. What can I do?

Inge

Joseph Schmidt

unread,
Nov 10, 2025, 5:03:00 PM (17 hours ago) Nov 10
to nv-form-m...@googlegroups.com
Did you click on the link at the top of my previous email?  It describes a request/approve process that can have multiple levels.


See request/approve.  

Over 1600 people have watched the videos or one person watch the first video 1600 times.

Let me know if you have any questions.  I have not reviewed the process in a long time.

Bart van Dalfsen

unread,
6:28 AM (4 hours ago) 6:28 AM
to nv-form-m...@googlegroups.com
Hi Inge,

Your question was: How to get my link to the detailsform in my response to actually work as a link.

Although many modern email-clients scan your attachments...
...(for undesired things like trojans, viruses and root- kits, malware-scripts and worms)...
...they also check the mail-contents for undesired messages...
...(such as spam and fishing)...
...and then can additionally do something they were not explicitly told by the sender to do but automagically can do for you anyway...
...such as resizing and embedded image to fit on it on your tiny or big display...
...and highlight or even create links from text recognised as an URL.

Long sentence, sorry for that.

Everything i just typed above was entered as plain text without any formatting.
Even this URL to www.google.com is plain text.
Your email application on your current device - on which you read this - may however show it as a link you can click on, although I never told or instructed it to do so.

Attention: for the rest of this mail  I'll start to use formatting my text to help you understand your what needs to be done.

We call text formatted if the appearance differs from the text we read. These can be cosmetic, like using bolditalics or underlined  or even colour.

A link is and advanced piece of formatting...
...shoutout to the physics engineer Timothy Berners-Lee for HTML, XML and the WWW...
...which not only allow a format to a sequence of characters in a text but...
...but also embeds directions to where you can go and the magic of getting there by clicking on this peace or hypertext.

So welcome to the higher level of communication :)

If you search for HTML LINK format, especially in the archives from this mailing group you'll find great instructions on how to put some specific html-tags in between your text - similar like you use the <<tags>> created by FormMule to create personilised responsemails - to format your link with the desired special effects ;)

(NL) En als het zoeken in het archief niet lukt of je hebt moeite met het creëren van een persoonlijke link die ook daadwerkelijk als link geformatteerd moet zijn laat het me dan via een PM maar even weten en dan zoek ik vanavond een oud voorbeeld voor je terug.

Fijne dag!

Cheers, Bart





Op ma 10 nov 2025, 22:53 schreef Inge <whatshop...@gmail.com>:
Reply all
Reply to author
Forward
0 new messages