[Fiona Bellinger]

Do you hear my scream of satisfaction when I got it to work 🙂 🙂 🙂

Thanks Rob, I have used one of the tutorials by Alice Keeler which uses a template as well as a tab creater.  And that combined with a little script referencing the Tab name as a cell from which data is selected means it is all automatic now.  No stuffing my wrist 🙂

I’ve cleaned and shared my spreadsheet if you want to see it at work.  Just run the Template Tab at the top.

https://docs.google.com/spreadsheets/d/11E0nS37SpmcBM0eSmRn6Je55QOjQOWyu6bn6z9OAYHQ/edit?usp=sharing

The final (i hope) thing is that I want to protect all but one of the spreadsheets.  Not a biggy but if I can have read only for majority of the tabs it would save potential corruption and means that the people who have access to it can only enter data in one place.  Prob being is that I really can’t be bothered going in and individually locking all tabs, and it wont do it automatically based on the Template Tab being locked.

Again, thanks Rob and Emma for your help and encouragement.

Fiona

 

 

[Fiona Bellinger]

Thanks for this both – my task tomorrow to look at this…. Your help and direction is really appreciated 🙂

[Fiona Bellinger]

The cells are automatically filled in based on the type of merge document I am using.  Merge letter 1 creates one set of columns, merge letter 2 creates a second set, Merge letter 3 a third set etc (Tho we are only using three types of letters).  Trying to auto-combine data into previous cell so the check can be done on this.

Issue is that this needs to be bomb proof for a colleague to use it…

Fiona

 

[Fiona Bellinger]

Correct – added Spreadsheet as a search word as a lot of the answers relate to DOC as its not reading OR in the appropriate manner.  Still trying to work it out.

Fiona

[Fiona Bellinger]

It is from computer use, so trying to take it very easy.  Having it checked also, and asking work to bring in OT 🙂

 

[Fiona Bellinger]

Thanks – I had posted it in Google Apps Script too so will recheck if got any answers that way.  Will also post in Stack Overflow as suggested.  My wrist is still injured so any script would be wonders, but will work on it slowly.  Meanwhile I have another question 🙂 . Which I’ll post separately…

 

[Fiona Bellinger]

Hi Rob,

https://docs.google.com/spreadsheets/d/1twxjJSNGpNtGNU_EZA1qqMzQ14kqKRDV1P3VZ0M_M-c/edit?usp=sharing

Changed it to edit access for anyone with the link, so hopefully that helps.

I thought it would be a script, which is something I have absolutely no experience with.

 

Fiona

[Fiona Bellinger]

Hi Rob,

I’ve got it working with FormRanger so thank you!

I’ve set the form if a name isn’t there, they have the option of choosing New Student, and going to a separate section to provide the necessary details.  If I understand correctly, I need to manually enter the new names on the master list, which with a click of a button on the form will update the fields in that form.

And one other query/concern – is there any point where I will reach overload? – I have 645 names in there at present 🙂

 

Thanks

Fiona

[Fiona Bellinger]

Oops – now unprotected…

Thanks,

Fiona

[Fiona Bellinger]

Hi Emma,

This is the only Regex expression I have built – very much trial and error and watching tutorials….

A colleague uses a mail merge spreadsheet to automatically produce and email letters.  Unfortunately she doesn’t pick up when there is an error and the merge doesn’t work or send.  I use this expression to locate the word INVALID in amongst all the automatic document merge status (ie: Document successfully merged; !!Error Sending Emails: Invalid email: <xxx Email>>; Manually run by [email protected]; Timestamp: Sep 20 2017 9:51 PM) , which results in the cell turning red and the work CHECK flash up.

Fiona

 

[Author]

Posts