Posts by FilipeTD • 118 points
9 posts
-
0
votes1
answer28
viewsA: Set value to another spreadsheet
Good afternoon, The code you must be looking for must be something like this. Remembering that I only made a few validations. For example if the spreadsheet you are saving the data reaches the…
-
1
votes1
answer669
viewsA: Create search box on google Docs
I made a solution in App Script that would be a conversion of your VBA. I hope it is what you need. The working file link is this:…
-
0
votes1
answer1378
viewsA: Google Sheets - Sending Email
code to update a cell. SpreadsheetApp.getActiveSpreadsheet().getSheetByName("mensagensEmail").getRange("celula").setValue("S"); Reference link with example: Setvalue app script…
-
2
votes1
answer3140
viewsA: Copy and paste into different sheets in Google Sheets
Use the function IMPORTRANGE(spreadsheet_key, range_string) of Google Sheets itself. Link to help you: http://www.mousewhisperer.co.uk/drivebunny/using-importrange-in-google-sheets/ function…
-
1
votes1
answer202
viewsQ: Insert data into Bigquery daily
I have a routine that returns me daily 2900 lines. This information is sent to Bigquery. Is there any way to send these 2900 lines today in a Bigquery table and tomorrow add another 2900 lines in…
-
1
votes0
answers29
viewsQ: Error using google sheets
A Google Sheets user made a call with an error in the use of Google Sheets. He worked with someone else’s shared spreadsheet and had full permission on the document. As she no longer needed to share…
-
2
votes1
answer161
viewsA: Configuring port in Tomcat
The solution I found was to create a file application.properties inside the directory src/main/resources with the code server.port = 2020. The mapping of the services is done correctly and the port…
-
2
votes1
answer161
viewsQ: Configuring port in Tomcat
I am developing various services and these are run at port 8080 by Tomcat. Since the next services to be generated are unrelated to the services that have already been generated, it was requested…
-
1
votes0
answers39
viewsQ: Using two Resultset + Userlist
I’m doing two distinct database searches that will return various data that will be entered in a list. I need to create a single list with this data. And the queries must concatenate with each…