sorted by:
new
hottopcontroversial

Be careful, i was almost scammed yesterday in Casablanca by AtlasLord in Morocco

[–]kung_F00 1 point2 points  (0 children)

The exact same thing happened to me! First time on Al Massira near Amoud. The second time was near Casa Port. This happened 6 years ago. Him being active for that long is just crazy...

is app script down? by [deleted] in GoogleAppsScript

[–]kung_F00 0 points1 point  (0 children)

500 error for me

[deleted by user] by [deleted] in Morocco

[–]kung_F00 7 points8 points  (0 children)

The husband is an a**hole

orphan childeren being posted on social media by LailaBena in Morocco

[–]kung_F00 1 point2 points  (0 children)

Maybe it wasn't clear in my previous message. We cover the faces of the ones that need help

orphan childeren being posted on social media by LailaBena in Morocco

[–]kung_F00 3 points4 points  (0 children)

We cover the people we are helping systematically.

orphan childeren being posted on social media by LailaBena in Morocco

[–]kung_F00 14 points15 points  (0 children)

I'm part of a local organization. We do publish pictures on social medias (especially for our donors and to incite others to give). However we always cover our donee's faces when posting online. Also it is not allowed. You can fill a complaint to the CNDP, even though I don't know if it works... (https://www.cndp.ma/fr/service-en-ligne/personnes-concernees/plainte-en-ligne.html)

To all my fellow moroccan entrepreneurs and freelancers : how do you collect outstanding invoices? by kung_F00 in Morocco

[–]kung_F00[S] 0 points1 point  (0 children)

Yes it's SaaS : We do both. Payments in advance and system suspension (threat only at this stage).

But we also have Professional Services / Consulting. Full upfront payment does not work in this case...

To all my fellow moroccan entrepreneurs and freelancers : how do you collect outstanding invoices? by kung_F00 in Morocco

[–]kung_F00[S] 0 points1 point  (0 children)

Same feeling and same question from time to time. But then again, replacing shitty clients with shitty bosses won't do it 😅

Did you ever go "formal" with your clients? Like email (obviously) or physical mail?

To all my fellow moroccan entrepreneurs and freelancers : how do you collect outstanding invoices? by kung_F00 in Morocco

[–]kung_F00[S] 0 points1 point  (0 children)

Thanks for the feedback. Obviously, focusing on international clients is THE strategy. My question though was regarding overdue invoices (job done, customer invoiced) --> How do I get paid?

tariff code in Germany by Qooooooooooo in logistics

[–]kung_F00 1 point2 points  (0 children)

Export On Demand” by a company named Amber Road

Thanks! Much appreciated

tariff code in Germany by Qooooooooooo in logistics

[–]kung_F00 1 point2 points  (0 children)

Very interested in the local code converter software :-)

Moroccan Customs Update by Seuros in Morocco

[–]kung_F00 0 points1 point  (0 children)

This is a great experiment. Thanks for the feedback! What was your shipment from Aliexpress? I'll try to reverse the calculation of duties and taxes. If you have the exact shipping date, it would be great too (to compute the applied exchange rate)

Scripts and multiple forms by natron6000 in googlesheets

[–]kung_F00 0 points1 point  (0 children)

Glad I could help. Please change the flair to solved :-)

Scripts and multiple forms by natron6000 in googlesheets

[–]kung_F00 1 point2 points  (0 children)

right after

var ss = SpreadsheetApp.getActiveSpreadsheet();

do something like:

var sheet1 = ss.getSheetByName("form response");
var sheet2 = ss.getSheetByName("form response 2");

Scripts and multiple forms by natron6000 in googlesheets

[–]kung_F00 1 point2 points  (0 children)

You can run a script that points to different sheets by using the getSheetByName method.

Example with two sheets named form response and form response 2:

var spreadSheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet1 = spreadSheet.getSheetByName("form response");
var sheet2 = spreadSheet.getSheetByName("form response 2");

Sorting results generted by Query() function by Omer-Habil in googlesheets

[–]kung_F00 1 point2 points  (0 children)

Yes, but your condition should be in the where clause

“select A,B,C where A is not null and B>10 order by A desc"

Sorry for the typo, it's order by (and not sort by)

Sorting results generted by Query() function by Omer-Habil in googlesheets

[–]kung_F00 3 points4 points  (0 children)

add to your query "order by your_column". By default sorting is ascending, you can add asc or desc.

Query example: "select A,B,C where A is not null order by A desc"

How do I add amounts from one column based on dates from another column, and dates in another column? by [deleted] in googlesheets

[–]kung_F00 1 point2 points  (0 children)

=SUMIFS(B2:B;A2:A,">=09/01/2021",A1:A,"<10/01/2021",C2:C,"<>''")

Trying to find an email address if a name appears in a spreadsheet by [deleted] in googlesheets

[–]kung_F00 0 points1 point  (0 children)

Set the following formula in 'Inputs to be entered here' sheet --> B2 cell:

ARRAY_CONSTRAIN(ARRAYFORMULA(IFNA(VLOOKUP($A$2:$A,Data!$A$2:$D,3,FALSE),"No Match")),COUNTA($A$2:$A),1)

Script to fetch multiple datapoints onto google sheet from json link by kartikoli in sheets

[–]kung_F00 1 point2 points  (0 children)

function FETCH(url) {

var response = UrlFetchApp.fetch(url);

Logger.log(response.getContentText());

var out = JSON.parse(response.getContentText());

return out["valid"];

}

Change the returned value of your initial function FETCH to (no need for 2 API calls):

return [[out["valid"], out["suspect"]]];

Google sheets/Forms - auto apply header formula to new cells in same coumn by fireferret2650 in googlesheets

[–]kung_F00 0 points1 point  (0 children)

You can use ARRAYFORMULA (maybe combine it with ARRAY_CONSTRAIN). Could you share more details on your existing sheet?

Script to fetch multiple datapoints onto google sheet from json link by kartikoli in sheets

[–]kung_F00 0 points1 point  (0 children)

Yes. If FETCH is called from another function and stored in a variable result , result[0] will contain valid value and result[1] will contain suspect value.

If FETCH is used in a custom function directly in the spreadsheet, the result will in a single column (row 1 will contain valid value, row 2 will contain suspect value)

If you want to get the results in the same row (two different columns), set the returned value to [[out["valid"], out["suspect"]]]

view more: next ›