Re: [Form Mule Google Group] Templates to use for each tab

[Joseph Schmidt]

I don't think you can do FormMule on two tabs on the same spreadsheet.  When you set up the second one, it would replace the first.

Where did you find that you can set up on two different tabs? Can you share the link?

I might be missing something.

You can use a separate spreadsheet for both and then use importrange to combine the data into one sheet.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Thu, Jun 15, 2023 at 10:35 AM Learning <gr...@joytalk.co.jp> wrote:

I am very new to this and just learning.  I would like to use FormMule in 2 tabs in the same Google Sheet, but I am not able to at the moment.  I have found information that says it is possible to run 2 instances of it, or to add a new rule, but I cannot find anything to help.  Any information would be greatly appreciated.  Thank you.

--
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 on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/b19fef82-a9eb-4a45-8f9f-a5b6d7381ccen%40googlegroups.com.

[Bart van Dalfsen]

Hi Grant?

The challenge is how to keep things simple :)

You will run sooner than later run into complexities and limits which will require you 

to undo the extra efforts and split the sheets again if you even got it to work, which i highly doubt.

Bare in mind, many words describing phenomena in spreadsheets are hard in other languages. A 'sheet' in Dutch is used to describe another slide in the same 'workbook' but i'm sticking to the word 'tab' to describe another 'slide' with an A1: address in the same spreadsheet 'file'.

If you read 'another sheet' but translated this to 'another tab' (within the same file) my imagination will forgive you.

I'ld still go for a sound and simple FM setup and rather merge multiple Gforms into one with a opening section to choose the desired (sub)form from the list and then goto the section with form x, y or z

I'ld create a slightly more complex column with a reply-or-not-trigger in the FormResponses tab and use multiple templates in FM to generate different kind of replies for different situations.

And now it dawns to me: you will get multiple tabs within the same sheet, each for another template (reply) based on the answers obtained from the submitted Forms...

...but not from multiple forms in the same sheet with each their own FormResponses tab.

FM won't object to this but demands at initial config to be select (one!) tab on which FM will operate and send replies.

And as you can only select one tab the answer is clear: you can't run FM in the same sheet on multiple tab's but you can diversify your "Artificial Intelligent" sheet using the much appreciated 'templates' from FM

Cheers from NL ;)

Bart

Op do 15 jun. 2023 20:33 schreef Joseph Schmidt <glua...@gmail.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/CAPWPTOSmNHQLOf4FysyR0PhUjW-csY1KBARzzRyeD_S%3DR-QU_Q%40mail.gmail.com.