Skip to main content

Home/ Sensorica Knowledge/ Group items tagged design

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Tiberius Brastaviceanu

Google Apps Script - introduction - 0 views

code.google.com/...guide_events.html

google script apps Programming javascript tool tools infrastructure

shared by Tiberius Brastaviceanu on 03 May 11 - No Cached
  • script that you want to run every day at a specific time
  • script that should run after a user submits a data-collection form.
  • Google Apps Script provides simple event handlers and installable event handlers, which are easy ways for you to specify functions to run at a particular time or in response to an event.
  • ...39 more annotations...
  • let's consider the terminology we use for events
  • event triggers
  • triggers
  • in response
  • event handler
  • event
  • onInstall function
  • onOpen function.
  • onEdit function
  • the simple event handlers are restricted in what they are permitted to do:
  • The spreadsheet containing the script must be opened for editing
  • cannot determine the current user
  • cannot access any services that require authentication as that user
  • Calendar, Mail and Site are not anonymous and the simple event handlers cannot access those services.
  • can only modify the current spreadsheet. Access to other spreadsheets is forbidden.
  • see Understanding Permissions and Script Execution.
  • The onOpen function runs automatically when a user opens a spreadsheet.
  • add custom menu items to the spreadsheet's menu bar.
  • onEdit function runs automatically when any cell of the spreadsheet is edited.
  • record the last modified time in a comment on the cell that was edited.
  • The onInstall function is called when a script is installed from the Script Gallery.
  • setting up custom menus for the user.
  • the script can call onOpen from onInstall.
  • Installable event handlers are set on the Triggers menu within the Script Editor, and they're called triggers in this document.
  • When a specific time is reached
  • When a form is submitted
  • When a Spreadsheet is edited
  • When a Spreadsheet is opened.
  • They can potentially access all services available to the user who installed the handler.
  • are fully-capable scripts with none of the access limitations of simple event handlers
  • may not be able to determine which user triggered the event being handled
  • The spreadsheet containing the script does not have to be open for the event to be triggered and the script to run.
  • You can connect triggers to one or more functions in a script. Any function can have multiple triggers attached. In addition, you can add trigger attributes to a function to further refine how the trigger behaves.
  • When a script runs because of a trigger, the script runs using the identity of the person who installed the trigger, not the identity of the user whose action triggered the event. This is for security reasons.
  • Installing an event handler may prompt for authorization to access
  • An event is passed to every event handler as the argument (e). You can add attributes to the (e) argument that further define how the trigger works or that capture information about how the script was triggered.
  • an example of a function that sends email to a designated individual containing information captured by a Spreadsheet when a form is submitted.
  • With Google Apps, forms have the option to automatically record the submitter's username, and this is available to the script as e.namedValues["Username"]. Note: e.namedValues are only available for Google Apps domains and not for consumer Google accounts.
  • The available attributes for triggers are described in the following tables.
  • Tiberius Brastaviceanu on 03 May 11
     
    script that you want to run every day at a specific time
Tiberius Brastaviceanu

Google Apps Script - introduction - 0 views

code.google.com/...guide_writing_scripts.html

google script apps Programming javascript tool tools infrastructure

shared by Tiberius Brastaviceanu on 03 May 11 - No Cached
  • Use the Script Editor to write and run scripts, to set triggers, and to perform other actions such as sharing scripts.
  • start the Script Editor from a Google Site
  • declares a function called myFunction()
  • ...69 more annotations...
  • You can perform the following tasks from the Script Editor.
  • pening, deleting, renaming, and saving scripts
  • Cutting, copying, and pasting text
  • Find and replace
  • Setting a time zone
  • scripts with time-based triggers
  • Running functions
  • Viewing log messages
  • revision history
  • write pseudocode first
  • When you're planning a script
  • narrative version of what the script needs to do.
  • A particular script is associated with one and only one Google Spreadsheet.
  • If you make a copy of the Spreadsheet, the script is also copied.
  • A particular Spreadsheet can have multiple scripts associated with it.
  • use the onOpen event handler in more than one script associated with a particular Spreadsheet, all scripts begin to execute when you open the Spreadsheet and the order in which the scripts are executed is indeterminate.
  • event handler is a function executed when a particular event takes place.
  • see Running Scripts in Response to an Event.
  • A script cannot currently call or create another script and cannot call functions in another script.
  • If you want to store the results of a function, you must copy them into a spreadsheet cell.
  • You can trigger Apps Script events from links that are embedded in a Google Site. For information about how to do this, see Using Apps Scrip in Your Ssite.
  • You can insert a script into a Site as a gadget.
  • you must grant permission for the script to run as a service.
  • You also designate whether only you can invoke the service or whether all members of your domain can invoke the service.
  • you can assign functions within the script any arbitrary name.
  • The instructions in a function must be enclosed within curly braces.
  • event handler
  • when a spreadsheet is opened,
  • when a script is installed
  • when a spreadsheet is edited
  • at times you choose
  • menu item
  • Using a drawing or button embedded in a Spreadsheet
  • Using a custom function that is referenced as a Spreadsheet function
  • Clicking the Run button
  • object-oriented programming languages
  • Google Apps Script uses the JavaScript language.
  • Operations
  • are performed using the objects and methods described in the API documentation.
  • An API provides pre-packaged code for standard tasks you need to accomplish in scripts or programs.
  • API includes objects that you use to accomplish tasks such as sending email, creating calendar entries
  • A method describes the behavior of an object and is a function attached to an object.
  • MailApp
  • use to create and send email
  • To send email, you invoke the sendEmail method and provide values for the method arguments.
  • Google Apps Script can access or retrieve data in different formats in different ways.
  • A custom function
  • is called directly from a cell in a Spreadsheet using the syntax =myFunctionName()
  • they cannot set values outside the cells
  • have some restrictions not shared by other functions
  • cannot send email
  • cannot operate on a Google Site
  • cannot perform any operations that require user authorization
  • cannot perform any operations that require knowledge of who the user
  • onInstall function
  • onOpen function
  • Other functions run when you run them manually or when they are triggered by clicking
  • Custom functions and formulas in the spreadsheet execute any time the entire Spreadsheet is evaluated or when the data changes in the function or formula's cell.
  • share the Spreadsheet
  • publish the script to the Script Gallery
  • spreadsheet template
  • the color coding for that line will not be correct
  • A script with incorrect syntax or other errors does not run.
  • The Script Editor includes a debugger.
  • view the current state of variables and objects created by a script while that script runs.
  • step through the code line by line as it executes or set breakpoints
  • The debugger does not work with custom functions, onEdit functions, event triggers, or scripts running as a service.
  • use the debugger to find errors in scripts that are syntactically correct but still do not function correctly.
  • Functions ending in an underscore (_), for example, internalStuff_(), are treated differently from other functions. You do not see these function in the Run field in the Script Editor and they do not appear in the Script Manager in the Spreadsheet. You can use the underscore to indicate that users should not attempt to run the function and the function is available only to other functions.
Tiberius Brastaviceanu

INSO-5-2015 - 0 views

ec.europa.eu/...2476-inso-5-2015.html

horizon 2020 proposal Tibi's selection Guillaume

shared by Tiberius Brastaviceanu on 02 Jun 14 - No Cached
  • Scope:  The scope is that of creating a Community, involving social innovators, researchers, citizens, policy makers, which will bring together on the one hand research actions and results and on the other implementation actions, new initiatives, and policy developments.
  • help promote social innovation initiatives
  • increase relevance of policies and actions
  • ...13 more annotations...
  • development of a common understanding
  • evidence and methodologies that contribute to social innovation up-scaling
  • This does not concern only European but also international developments.
  • Such a social innovation community could be seen also as a “network of networks”.
  • Activities should include:
  • rganisation of brokerage events to enhance the networking
  • information and awareness activities t
  • design strategies/activities for ensuring the best possible use of the research results
  • the organisation of events aimed at identifying priorities for collaboration
  • supporting grassroots experiments, replication, incubation and policy uptake of research results
  • setting up of a network of 'Local Facilitators' for a better dissemination and uptake at all levels.
  • EUR 3 million
  • enable convergence towards a common understanding of social innovation as a tool and outcome.
  • Tiberius Brastaviceanu on 02 Jun 14
     
    "Topic: Social innovation Community INSO-5-2015"
Tiberius Brastaviceanu

Atelier barda - 0 views

atelierbarda.com/index.html

collaboration possible collaborator local Montreal architecture design

shared by Tiberius Brastaviceanu on 13 Aug 13 - No Cached
  • Tiberius Brastaviceanu on 13 Aug 13
     
    are interested in urban agriculture, near CTS.
nicanorgonzalez

Open Design 3D-Printable Adjustable Micropipette that Meets the ISO Standard for Accuracy - 0 views

www.ncbi.nlm.nih.gov/...PMC6187506

tool Tools

shared by nicanorgonzalez on 04 Dec 20 - No Cached
  • nicanorgonzalez on 04 Dec 20
     
    micropipettes are expensive, here is a 3d printed alternative.
sebastianklemm

Binance Charity - 0 views

www.binance.charity/project-lists

greens_for_good funding platform

shared by sebastianklemm on 25 Jun 21 - No Cached
  • sebastianklemm on 25 Jun 21
     
    Perhaps, this is a possibility to either fundraise Crypto for direct implementations of a device at a community in need OR raise follow-up funding for the current design phase. Binance Charity "Fight-Hunger-Worldwide" campaign*: https://www.binance.charity/fight-hunger-worldwide Perhaps, "Greens for Good" can connect with this campaign by Binance Charity.
marjababernard

Protein Extrusion | How Bonnot Is Working On Plant-Based Protein Extrusion - The Bonnot... - 0 views

www.thebonnotco.com/plant-based-protein-extrusion

greens_for_good organization

shared by marjababernard on 29 Apr 21 - No Cached
  • marjababernard on 29 Apr 21
     
    An American based supplier of custom designed processing equipment including plant protein extruders.
« First ‹ Previous 101 - 120 of 143 Next › Last »
Showing 20▼ items per page