• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Good Tutorial on Google Forms, Google sheets, and the "Array Function" (2 Viewers)

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 16:35
Joined
Jul 9, 2003
Messages
11,976
This is a nice example of using Google forms together with a Google sheet. Also Demonstrated is an "Array Function" Which can replace the need for having a formula for each row. For example you may have situation where a function in Column "C" Adds the value in column "A" to the adjacent value in column "B" and places the "SUM" in column "C" a formula in Each Cell of "C". This Video shows you how to produce an "Array Function" which does the calculation of all the values in ONE GO! Very useful and alludes to a technique I have yet to understand.
Google Forms - Formulas in Sheets That Autofill with Submit

 

Users who are viewing this thread

Top Bottom