Hi,

I have created a Firebase project, and initialized the realtime database.

I created a Google Cloud pub/sub cloud function that triggers when a new publication is received by pub/sub.

However, the provided samples  for cloud functions only show how to write a "hello world" to the console, but I am trying to find a way to make this cloud function insert a record into the FireBase realtime database.

Any clues on how to achieve this will be greatly appreciated.

Thanks a lot
Screen-Shot-2017-10-22-at-11.43.46-P.png
Screen-Shot-2017-10-22-at-11.43.46-P.png

Hi All,

I'm trying to increment column H by 1 when Column I is changed to Yes.  When Column H is incremented, then Column L should be set to 1 to indicate it's been updated for the week already.  If Colum L is 1 then I don't want column H to be incremented at all.

In a separate function, I want to set all the values in column L back to 0 so that the trigger on Column I can now increment as needed.

I've started it, but I really don't know enough in the Google Docs language to get it actually working.  I attached an image of the sheet so you can see the layout.

function onEdit(e){

  var range = e.range;
  var cellValue;
 
  if range.getcolumn() == 9 and range.value = "Yes"{
     //cellValue = cell.getValue();
     //cell.setValue(cellValue + 1);
  }  
}
 
Any help is greatly appreciated.

Thank you!

Hi

I got a spam from Cassi at Exact Data that claimed that Yahoo PPC ads are the next big thing. I didn't click anything, of course.
Having done Google for years, is there any truth in this claim?

Are Scammers sending any semi-plausible tech ads around to click-bait developers?
Is Adsense still the way to go for ads ?

Thanks

Hello,

Please, can somebody help me with this issue? I have a website and want to be added to Google News but they reject my submission. The website URL is -> https://www.airlineratings.com/.

If you have some information what I should change on my website to meet the Google News recommendations, please send them to me.

Much appreciated.

I'm looking forward to your reply.
Best Regards,
Kevin

hi,

I can use VBA to download csv files published from google sheets with the function below which works well. However I also want to download csv files from another site that has the following format:

https://www.airbnb.co.uk/transaction_history/csv/XXXXXX?pending=1

(this is the URL that shows in the download history)

However all I get in the attached HTML file. Is there a way I could alter the VBA code to obtain the csv?

Thanks

Function DownloadFile(myURL, saveToPath)

Dim WinHttpReq As Object
Set WinHttpReq = CreateObject("Microsoft.XMLHTTP")
WinHttpReq.Open "GET", myURL, False, "username", "password"
WinHttpReq.send

myURL = WinHttpReq.responseBody
If WinHttpReq.Status = 200 Then
    Set oStream = CreateObject("ADODB.Stream")
    oStream.Open
    oStream.Type = 1
    oStream.Write WinHttpReq.responseBody
    oStream.SaveToFile saveToPath, 2 ' 1 = no overwrite, 2 = overwrite
    oStream.Close
End If

End Function

Select all Open in new window

airbnb_txn_pending.csv

Were within the Google Drive Admin console do I need to go to see how large each user's Google Drive folder is?

Hi all,

We have a Google Sheets worksheet that several people have access to. Everyone needs editing privileges so that they can input data.

However, on occasion, one user will delete data by mistake. Is there any way to allow users only to add/modify, but not let them delete?

Or, allow them to add/modify/delete only their entries?

Thanks in advance.

A colleague indicated that he prefers iPhone over android phone because the iPhone is entirely encrypted and all apps download from the Apple store passes thru rigorous process prior being placed on the store.  On the other hand, android phone are not encrypted and you can download apps from anywhere, besides the store; in other words there is little control as to the google store apps as to security.  Finally all who developed apps for iPhone have to pay an anual fee to Apple where as to android no fee - insinuating at one point that a hacker can create an apps load it to google store and all can download it; thus being able to reach millions with ease.

Is there any accuracy to this persons comment? Please advice.

Hi,

I have a simple need of a gallery plug-in. After looking at some 20 of them I am really frustrated since All are jpg and do not give the options to have a simple gallery like on the old days where each picture had a normal URL.

Its quite simple what I try to do here. Please excuse the url, because this is real old. I did this in 2004
http://malaysiamission.com/photo.html

all these photos with descriptions are still in google, if you search for any names in these galleries they come up in google with description. This is what we try to do with this gallery., but instead there is even hard to find something that allows to have the cation under the picture.

Does anyone have any idea if such a plug-in exists?

I would be very happy if anyone has a tip for me because it seems so simple but everyone offers the fancy ways to display them. This is all fine but in the end I want these pictures in google as pages with the names of the people in the photo. I try to have clean URLs for each photo as well.

Anyone know if something like this?

Best wishes,
Thom

i can't disable important mark in my Gmail.
all direction says setting > inbox > no "important markers" done it but still no change
Gmail still mark important and hide them into important folders.
extremely frustrating as you can't see it  in both Outlook and Iphone .
how one can o disable important function for good?
Screen-Shot-2017-10-14-at-12.21.53-P.png

I am using google maps api including MarkerWithLabel.
For some reason when changing the map zoom (using the map controls) markers seem to lose their exact location.
Code below. Please if someone can help to keep the markers in place when zooming in-out. Thank you!

var map = new google.maps.Map(document.getElementById("map"), {
  center: new google.maps.LatLng(52.554201,13.425703),
  zoom: 16,
  streetViewControl : false,
  overviewMapControl: false,
  mapTypeControl: false,
  zoomControl : true,
    zoomControlOptions: {
      position: google.maps.ControlPosition.RIGHT_BOTTOM
    },            
  panControl : false,
  scrollwheel: false,
  fullscreenControl: true,
  mapTypeId: google.maps.MapTypeId.ROADMAP
});

google.maps.event.addDomListener(window, "load", function () {

function createMarker(options, html) {
    var marker = new google.maps.Marker(options);
    return marker;
  };

var marker = createMarker({
    position: new google.maps.LatLng(56.554201,19.425703),
    map: map,
    cursor: 'hand',
    icon: "images/location.png",
  });

var marker2 = new MarkerWithLabel({
        position: new google.maps.LatLng(53.549140,14.428730),
        icon:'images/pointers.png',
        map: map,
        labelContent: "Agni <span>Shop</span>",
        labelAnchor: new google.maps.Point(44,86),
        labelClass: "labels",
        labelStyle: {opacity: 1}
     });

});

window.onresize = function() {
  var currCenter = new google.maps.LatLng(52.555564,13.426775);
  

Select all Open in new window

…

I have transferred passwords between Google Chrome number of times before and it worked a treat. Recently when I tried to do this (Chrome version 61.0.3163) from Windows 7 32bit to Windows 10 64 bit it just did not work.

It seems that transferring Login data and Login data journal does not have any effect anymore.

• there's no Import and Export button under the Manage Passwords menu so this method is not available for me

• attempts to bring back Export settings button via Flags menu to disable Material change settings were not successful. The very much needed button did not show

• exporting via store passwords on passwords.google.com not an option as it's blocked for security reasons

• logging user to Chrome for Chrome to store passwords under users profile not an option for the very same reasons

• use of third party software like Chromepass from Nirsoft not an answer since I am not after previewing but transferring passwords

Has anyone got any ideas how to achieve what I am after - full transfer for passwords between Chrome installations please?

For some reason no one in the company can visit https://www.amctheatres.com/ we get the following error message.
"
The requested URL was rejected. Please consult with your administrator.

Your support ID is: 15532489170173462385

[Go Back]
" 
It works fine outside of the network.
I have checked DNS for root kits and nothing came up. I changed the DNS on two computer to point to google (8.8.8.8) same result.

I did trace route and it looks normal.

Tracing route to 169.224.240.210 over a maximum of 30 hops

  1     2 ms     3 ms     2 ms  x
  2    <1 ms    <1 ms    <1 ms  x
  3     2 ms    16 ms     7 ms  r-uwmadison-isp-ge-7-0-1-2931.wiscnet.net [140.189.64.109]
  4     6 ms     6 ms     6 ms  r-222wwash-isp-ae2-3900.wiscnet.net [140.189.9.77]
  5    28 ms    22 ms    23 ms  madix-hurricane.net.wisc.edu [144.92.233.244]
  6    38 ms    19 ms    24 ms  10ge14-2.core1.chi1.he.net [184.105.222.57]
  7    24 ms    23 ms    23 ms  100ge14-1.core2.chi1.he.net [184.105.81.97]
  8    35 ms    29 ms    29 ms  100ge12-1.core1.mci3.he.net [184.105.81.209]
  9    30 ms    30 ms    34 ms  arsalon-technologies.gigabitethernet1-9.core1.mci3.he.net [184.105.250.62]
 10    31 ms    30 ms    30 ms  204-13-97-250.arsalon.net [204.13.97.250]
 11    40 ms    40 ms    40 ms  169.224.240.210

I did a packet capture and it looks normal.

so I am not sure what the issue is.

Any thoughts would be appreciated. Thanks!!!