Categories
User Help Web Apps

IF, THEN Google Sheets formula help

I’m having trouble figuring out the right formula for an if, then scenario in Google Sheets. I have two tabs of separate spreadsheets open in one Google Sheet. I need the second tab (Cost Analysis) to reference the first tab (Responses). In Responses I have 3 columns that say either Mimaki or Roland and 3 […]

Categories
CMS Drupal Mastering Development

Select in a first form / menu, the choices of other fields in other forms

I have three types of content, which represents categories. In each type of content, I have a first field which offers to select a subcategory (different subcategories depending on the type of content). To simplify the creation of a node for my users, I would like them to be able to select in a first […]

Categories
CMS Drupal Mastering Development

Select in a first form / menu, the choices of other fields in other forms

I have three types of content, which represents categories. In each type of content, I have a first field which offers to select a subcategory (different subcategories depending on the type of content). To simplify the creation of a node for my users, I would like them to be able to select in a first […]

Categories
CMS Drupal Mastering Development

Select in a first form / menu, the choices of other fields in other forms

I have three types of content, which represents categories. In each type of content, I have a first field which offers to select a subcategory (different subcategories depending on the type of content). To simplify the creation of a node for my users, I would like them to be able to select in a first […]

Categories
Mastering Development

Is there a succinct list of all perl stateful operators and modifiers?

Details for the stateful behaviour for operators such as match (ie. m//g), stat (ie. stat _) and range (ie. //..//) are in the documentation. However is there a ‘listing’ of all operators or functions that exhibit stateful behaviour? The ones that come to mind are: #ARGV/File/dir/glob: The current line/position is remembered say while <>; #Read […]

Categories
Mastering Development

TypeError: obj is not a function

I have an object like: {a:1,b:2,c:3} I’m trying to build a sqlite update statement dynamically using: function update_json_obj_into_table(tablename, obj) { const insertValues = Object.keys(obj).reduce((acc, k) => acc + (k + ‘ = ‘ + obj(k) + ‘,’), ""); console.log(insertValues); // db.run(`UPDATE ${tablename} SET ${insertValues} WHERE search_condition`); }; based on https://www.sqlitetutorial.net/sqlite-update/ I want insertValues to look […]

Categories
Ask Geographic Information System (GIS)

Forest Development Change Detection using LandTrendr for GoogleEarthEngine

I would like to create a map that shows the year of the detection of a forest disturbance. Unfortunately I only have basic knowledge of GEE and LandTrendr. I would like to create the analysis on a pixel basis for a complete national park. I have already created code with the help of the forum, […]

Categories
Mastering Development System & Network

Disabling clipboard and drive redirection between two non trusting domains, but allowing it while inside the domains

There are 2 Active Directory forests/domains, let’s call them A and B, no trust exists among those, the network were completely separate until recently. There is now a link between the 2 networks, to allow rdp connectivity from A to B, but not vice versa. It works fine. Let’s call Ax (e.g. A1, A2, .. […]

Categories
Ask Geographic Information System (GIS)

Filter scene overlap in image collection

How can I filter areas of scene overlap so that each pixel only has data from one landsat scene? My goal is to have as many images as possible while also maintaining a uniform number of images across the area of interest. Here is a map showing image count in the collection (darker areas have […]

Categories
Mastering Development

How to Sum NA (text NA) values in excel with numbers by treating NA as 1

I have a table A B C 1 Param1 Param2 Param3 2 1 NA NA 3 0 1 NA 4 0 0 NA 5 1 NA 1 Expected output A B C D 1 Param1 Param2 Param3 Output 2 1 NA NA 3 3 0 1 NA 2 4 0 0 NA 1 5 1 […]