## 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 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?

## 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_capability`that 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.

## Are there any lambda calculus functions that always issue booleans but are not constant functions?

In the Labmda calculus, true = $$lambda x, y.x$$ and wrong = $$lambda x, y.y$$,

Is there a term? $$f$$ so for every other term $$x$$, $$f x$$ normalizes to true or false, BUT $$f$$ does not have the same output for all inputs?

## Closed class containing infinitely many noncongruent pairwise functions

Prove that if a closed class in P2 contains a function that essentially depends on n ≥ 2 variables, it contains infinitely many noncongruent pairwise functions.

## 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).