How do I perform multiple onEdit functions in Google Script (Google Sheets)?

I tried many different options and none worked.

I want a feature where someone enters something, the content of the cell is automatically capitalized and all accents removed.

For example: If I enter "áéîõíúú", it immediately becomes "AEIOAAUU".

I have tried the following cases:

  1. Change the accented letter to a normal letter and then write everything in uppercase onEdit;
  2. Separate the functions into different ones onEdit;
  3. only one onEdit this calls the functions in another script.

This is my code:

Function onEdit (e) {
To attempt{
myA (e);
myE (e);
myUpper (e);
}
catch (e) {
if (e) {}}
}

Function myFunction () {
var app = SpreadsheetApp;
var targetSheet = app.getActiveSpreadsheet (). getSheetByName ("Sheet1");

onEdit ();
} 

The functions "myA", "myE" and "myUpper" are each in separate scripts and are:

Function myUpper (e) {
e.range.setValue (e.value.toUpperCase ());
}

Function myE (e) {
e.range.setValue (e.value.replace (new RegExp ("[[éèêëÉÈÊË]"," g ")," E "));
}

Function myA (e) {
e.range.setValue (e.value.replace (new RegExp ("[[áàâäãÁÀÂÄÃ]"," g ")," A "));
}

When you run all the code, only the "myE" function works. In other words, only the letter "e" with accents becomes "E".

What am I doing wrong?

Thank you in advance.

7 – Functions that do not recognize all recoverable functions in the first pass

vagrant @www-xxx-com: / var / www $ drush fr xxx_inspiration
Are you sure you want to restore xxx_inspiration.field_base? (y / n): y
Xxx_inspiration.field_base has been reset.                                      [ok]
Are you sure you want to restore xxx_inspiration.taxonomy? (y / n): y
Xxx_inspiration.taxonomy has been reset.                                        [ok]
Are you sure you want to restore xxx_inspiration.variable? (y / n): y
Xxx_inspiration.variable reset.                                        [ok]

vagrant @www-xxx-com: / var / www $ drush fr xxx_inspiration
Are you sure you want to restore xxx_inspiration.field_instance? (y / n): y
Xxx_inspiration.field_instance has been reset.                                  [ok]
Are you sure you want to restore xxx_inspiration.page_manager_pages? (y / n): y
Restored xxx_inspiration.page_manager_pages.                              [ok]
vagrant @www-xxx-com: / var / www $ drush fr xxx_inspiration
The current status is already the default and will be canceled.                         [ok]

If I reset the function for the first time, 3 subfunctions would be reset. Then I have to run it again.
Why is this happening?

Allow custom functions to manage plugin options

Is it possible to give a custom function the ability to manage the options of certain plugins?

I'm developing a bunch of plugins, a main module with some extra modules. The main function adds a custom role and capability so that this role is an editor and the rest of the plugins in the suite can be managed and edited.

// in main plugin on activation hook
$ permissions = get_role (& # 39; editor & # 39;);
$ permissions = $ permissions-> skills;
$ Permissions[ 'custom_capability' ] = 1;

add_role (& # 39; custom_role & # 39 ;, __ (& # 39; Custom Role & # 39 ;, $ permissions);

To access the plugin pages, I have the ability when registering the options page of the plugin components custom_capabilitythat has worked to make the plugins visible to those who use the Custom role Role.

add_submenu_page (& # 39; custom-plugins & # 39 ;, & # 39; custom plug-in addons & # 39 ;, & # 39; addon & 39 ;, custom_capability & 39; custom-plugins) -addon & # 39 ;, & # 39; add_custom_addon_options_page & # 39;););

However, If this role tries to update the plugin settings, access is denied,

I tried it option_page_capability Filter, but was not lucky.

// In additional modules when registering the options page
Function give_custom_role_access () {
return & # 39; custom_capability & # 39 ;;
}
apply_filters (? option_page_capability_custom_addon_options_page ?,? give_custom_role_access & # 39;); 

There seems to be some confusion about what should go in {$ option_page} when using the option_page_capability _ {$ option_page} So I've tried both the page slug option and the slug settings group, but both did not work.

Device recommendation – Which functions should be considered when selecting a ring flash?

In particular, if you are considering an older device, especially if it is not TTL, check how low it can go in power.

An example of a device that is difficult to use today is the Soligor AR-20, which is not uncommon on the used market. This is a computer flash (external photocell) that is only specified for 20 cm and more subject distance and is intended for use either f / 8 or f / 16 at ISO 100.

Some DSLRs / DSLMs do not even have ISO 100 anymore, and with the F / 8 you have little room to maneuver, if you need to get closer or make one or two stops, your aperture is f / 22 (great DoF, but you are here in deep diffraction area … and when did you last clean your sensor? :)) and still overexposed ….

Numerics – Calculation between gamma functions

I've calculated the gamma functions in Mathematica while there is no agreed answer.

By definition, $ Gamma[alpha]= int_0 ^ infty t ^ { alpha-1} e ^ {- t} dt $, $ Gamma[alpha,z]= int_z ^ infty t ^ { alpha-1} e ^ {- t} dt $ and $ Gamma[alpha,z_1,z_2]= int_ {z_1} ^ {z_2} t ^ { alpha-1} e ^ {- t} dt $, So we should have $ Gamma[alpha]-Gamma[alpha,z]$ should be the same $ Gamma[alpha,0,z]$, This is not the case. I'll just leave it $ alpha = 200 $ and $ z $ from 1 to 5 the numbers do not fit; see below.

    α = 200;
table[{Gamma[α] - gamma[α, z]gamma[α, 0, z]}, {z, 1, 5}]{{0th * 10 ^ 359, 0.00184859}, {0. * 10 ^ 359, 1.0983 * 10 ^ 57}, {0. * 10 ^ 359.6.71225 * 10 ^ 91},
{0th * 10 ^ 359, 2.41279 * 10 ^ 116}, {0. * 10 ^ 359, 2.14999 * 10 ^ 135}}

Why this?

style – functions for multiple fonts

I'm looking for a bunch of characters with different fonts, but it's pretty bulky code if I have to customize each text to have the font / size it should have.
Is there a way to get functions to apply fonts to text, for example:

S[x]: = Style[x,Bold,12,FontFamily->"Arial"];
T[x]: = Style[x,Italic,12,FontFamily->"Symbol"];

These do not seem to work because the functions work with variables while I search for a string operator S["A"], P["B"], T["p"], etc.

Algebraic Geometry – When is the stem of a locally annular space completely closed in the ring of rational functions?

To let $ X $ to be a place that is surrounded. To let $ text {Rat} (X) $ let the ring be rational functions $ text {colimit} _ {U text {open, close in} X} mathcal {O} _X (U) $ on $ X $, Accept for convenience $ X $ has a generic point $ x $, For a point $ y in X $ with stalk $ mathcal {O} _ {X, y} $When is the morphism? $ mathcal {O} _ {X, y} rightarrow text {colimit} _ {U text {open, dense} X} mathcal {O} _X (U) $ completely closed? (When all elements of the target are integrally closed over the image).