Knowledge Satnavis in the Business Intelligence Industry

Knowledge Satnav

The wait is over! - it’s time to celebrate the champion startups of the world. Shout out to all of the participants in our ! You did a wonderful job showcasing your incredible startups and powering through another year. 2023 Startups of the Year is a community-driven voting platform brought to you by HackerNoon that recognizes and celebrates tech startups changing technology and the world for the better. The award started on May 8th, 2023, where the internet nominated and voted for 30k startups around the world. The voting period remained open until December 31, 2023, and now we are here with the winner announcement after a comprehensive evaluation by the HackerNoon team. Startups of the Year 2023 To see the top 3 startups in each respective city, visit and pick a city. hackernoon.com/startups You’ll get a little surprise 😉 Here are the Startups of the Year Regional Announcements: North America Europe Asia Africa South America Oceania Misc/Remote From all of us at HackerNoon, thank YOU for your excellent campaign perseverance 🥺 This year has been awesome! Startups of the Year 2023 is concluded with 623k+ total votes, up from 215k+ votes in the inaugural startup competition. We look forward to seeing you again in the next campaign (stay tuned 😉)! Without further ado, let us kick off the announcement by celebrating the cities with top votes per region for 2023 🎉 North America (11,697 votes): Winner: Bloomfilter Cleveland, Ohio (8,835 votes) - Winner: SerpApi Austin, Texas , California (5,564 votes) - Winner: Finch San Francisco (4,258 votes) - Winner: RELAYTO SoMa, California - (3339 votes) Winner: Windscribe Toronto, Canada, North America (3304 votes) - Winner: Vouched Seattle (2716 votes) - Winner: Seccuri Palo Alto, CA, North America (2671 votes) - Winner: Salsa Valley Miami, FL, North America (2,613 votes) - Winner: Majhi Group Manhattan, New York (2423 votes) - Winner: Flieber, Inc. New York City, NY, North America See the complete announcement for the . Startups of the Year, North America, here Europe (45,612 votes) - Winner: Algomo London, UK (2,344votes) - Winner: Data Lake Warsaw, Poland (1,955 votes) - Winner: Hoken Tech Bari, Italy (1716 votes) - Winner: Not8 Amsterdam, Netherlands (1657 votes) - Winner: KYVE Frankfurt Am Main, Germany (1566 votes) - Winner: BazaIT Kyiv, Ukraine (1496 votes) - Winner:  Unity Network Tallinn, Estonia (1,478 votes) - Winner: Volcaino Ghent, Belgium (1,288 votes) - Winner: Owl Me Dublin, Ireland (1198 votes) - Winner: Groover Paris, France See the complete announcement for the . Startups of the Year, Europe, here Oceania (3,350 votes) - Winner: Sharepass Melbourne (2,107 votes) - Winner: The Catfisher Project Perth, Australia (220 votes) - Winner: Gemini AI Solutions Auckland, New Zealand, Oceania (213 votes) - Winner: Nexustorage Wellington, New Zealand, Oceania (138 votes) - Winner: Coviu Sydney (124 votes) - Winner: Bopple Brisbane, Australia, Oceania (124 votes) - Winner: Regional CFO New South Wales, Australia, Oceania (106 votes) - Winner: Edit on the Spot Gold Coast, Australia, Oceania (93 votes) - Winner: Knowledge Satnav Canbera, Australia, Oceania , Australia, Oceania (48 votes) - Winner: Peptalk360 North Melbourne, Melbourne See the complete announcement for the . Startups of the Year, Oceania, here Asia (16,345 votes) - Winner: Serenity Shield Singapore (13,588 votes) - Winners: QUIXY Telangana, India (10,168 votes) - Winner: HealthySure Mumbai, India (3,865 votes) - Winner: InterviewBuddy Visakhapatnam, India (3,733 votes) - Winner: Omniflo Bengaluru, India (4589 votes) - Winner: MeNow Tel Aviv (3877 votes) - Winner: ForestVPN Dubai (2478 votes) - Winner: TechGraph Powai, Mumbai, India (1004 votes) - Winner: Reelo Ahmedabad, GJ, India (875 votes) - Winner: Debt Hunter Hong Kong, China See the complete announcement for the . Startups of the Year, Asia, here Africa (8,179 votes) - Winner: GO PLATFORM Algiers, Algeria (767 votes) - Winner: Tudu Accra, Ghana (415 votes) - Winner: Treford Lagos, Nigeria (265 votes) - Winner: Phalconwise Ogbomosho, Nigeria (157 votes) - Winner: AbuErdan Cairo (151 votes) - Winner: Eazipay Lekki (144 votes) - Winner: KaziConnect Dar es Salaam, Tanzania (101 votes) - Winner: faceATT Gauteng, South Africa (79 votes) - Winner: Dimagi Cape Town (71 votes) - Winner: Sabi Addis Ababa See the complete announcement for the . Startups of the Year, Africa, here South America (376 votes ) - Winner: UpGirl Santiago, Chile (217 votes) - Winner: Klever Sao Paulo, Brazil (191 votes) - Winner: Tributo Simple Buenos Aires, Argentina (127 votes) - Winner: Light-it Montevideo, Uruguay (87 votes) -Winner: Thousand Antioquia, Colombia (108 votes) - Winner: GetLavado Lima (101 votes) - Winner: Cogniflow Medellin (73 votes) - Winner: TPAGA Bogota (73 votes) - Winner: Reliv Quito (47 votes) - WInner: Quantex Cordoba See the complete announcement for the . Startups of the Year, South America, here Misc/Remote: Featured Startups (1500 votes) - Winner: CIC Chain Remote, Earth (1193 votes) - Winner: Reship Colony US Misc (146 Votes) - Winner: Partful UK, Misc (116 votes) - Winner: GoMining British Virgin Islands Misc (283 Votes) - Winner: tomorrowSpace Germany Misc (225 votes) - Winner: Dtravel Cayman Islands See the complete announcement for Misc/Remote startups . here Once again, HUGE CONGRATULATIONS and BIG PROPS to all of the top Startups of each region this year! The whole team at HackerNoon would like to thank you for your perseverance in the campaign, and we look forward to seeing you in the next campaign. About HackerNoon’s Startups Of The Year Startups of The Year is HackerNoon’s Flagship community-driven event celebrating startups that survived and thrived in 2023. 30,000 startups across 4200+ cities and six continents participated this year to be crowned the best startup in their city. Visit our page to learn more. FAQ Companies that blog more get 67% more leads - Jumpstart your company’s blogging journey by purchasing our . Business Blogging Package The 2023 Startups Of The Year is sponsored by: . . The winners get a free .Tech Domain, a HackerNoon NFT, and a Tech Company News Page. TECH Domains

Stand Up for the Champion Startups of the Year! 

বছরের চ্যাম্পিয়ন স্টার্টআপের জন্য দাঁড়ান!

Setzen Sie sich für die Champion-Startups des Jahres ein!

¡Defiende a las startups campeonas del año!

Défendez les startups championnes de l’année !

वर्ष के चैंपियन स्टार्टअप के लिए खड़े रहें!

今年のチャンピオンスタートアップのために立ち上がろう!

올해의 챔피언 스타트업을 위해 일어서세요!

Defenda as startups campeãs do ano!

Встаньте на защиту стартапов-чемпионов года!

Yılın Şampiyon Startup'ları için Ayağa Kalkın!

Hãy ủng hộ các công ty khởi nghiệp vô địch của năm!

为年度冠军初创企业挺身而出！

The Moon has long fascinated humankind, inspiring countless myths, stories, and scientific inquiries. Our understanding of the Moon has shifted gears in recent years owing to several outer space missions that explored geology, surface, and, mineral resources. The idea of building a lunar economy has existed for some time now. To make it a reality, scientists will have to set up a communication and navigation infrastructure with a standardized way to determine time. NASA is currently in the early stages of developing , a vital initiative to create an internet network for the Moon. This project goes beyond enabling astronauts to take pictures; it is a crucial component of the program. The agency intends to build various infrastructures on and around the Moon, such as a , a new , and a lunar web service that can maintain connectivity between all elements. LunaNet Artemis human habitat space station “LunaNet is a framework of mutually agreed-upon standards, protocols, and interface requirements allowing future lunar missions to work together, conceptually similar to what we did on Earth for joint use of GPS and Galileo,” Javier Ventura-Traveset, ESA's Navigation Manager. explains LunaNet: Enhancing Connectivity and Empowering Missions at the Moon “As NASA establishes a sustained lunar presence on the Moon, creating a robust infrastructure becomes increasingly important. The LunaNet communications and navigation architecture is extensible and flexible,” D.J. Israel, Exploration and Space Communications Projects Division Architect in a conference paper titled “LunaNet: a Flexible and Extensible Lunar Exploration Communications and Navigation Infrastructure.” states He further explains how LunaNet will provide three types of services: networking, position, timing and navigation, and science utilization. Users, both human and robotic, will experience network functionality similar to that experienced on Earth. The ESA(European Space Agency) opened an last week,  inviting private companies to help with its program, aimed at launching  three or four satellites to be “carried into lunar orbit by a space tug and deployed one by one, to form a constellation of lunar satellites.” The satellite constellation's orbits will be strategically optimized to encompass the lunar south pole, which has been designated as the primary landing site for  NASA’s future Artemis missions. application portal “Moonlight” What is ESA’s Moonlight initiative? “Many of the proposed lunar missions will require reliable navigation and telecommunication capabilities. Building these capabilities independently would be inefficient and costly due to complex, recurrent developments,” ESA’s announcement blog post titled “Lunar Economy Applications” . read Not only ESA, but NASA has also adopted public-private models for providing space services, such as and to the International Space Station. These partnerships have also been established for future endeavors, including the and to the lunar surface. delivering cargo transporting crew delivery of scientific experiments astronauts NASA has invested $1.2 billion in to develop a human landing variant of to land American astronauts on the Moon under Artemis III,” marking humanity’s first return to the lunar surface in more than 50 years.” SpaceX Starship Of the total investment in space over the last decade, which , 99% was directed toward the development of satellites and their launch vehicles for Earth's orbit. The emerging markets of space habitats, satellite servicing, and the fledgling lunar market accounted for $3.3 billion of this investment. amounted to $272 billion The US-based space agency anticipates that the lunar network will expand along with the increase in activity on and around the Moon. It projects that with the establishment of the Lunar Gateway, its newly planned lunar space station, the Moon will require approximately 210 megabits per second and 4.6 terabytes per day, as stated in a from the agency in the previous year. As NASA prepares for a human mission to Mars around 2035, it foresees the Moon requiring as much as 950 megabits per second and 12 terabytes per day. presentation "In 2021 there were 13 landers, orbiters, and rovers on and around the Moon," Kelly Larson, CEO of Aquarian Space, in the statement. "By 2030, we will have around 200, creating a multibillion-dollar lunar economy.” said NASA is devising a plan to enhance its services by launching lunar satellites that will interconnect with each other and eventually link back to the communication infrastructure on Earth. will be especially beneficial for the challenging-to-reach parts of the Moon, such as the far side and the lunar south pole, which the agency aims to explore with the aid of astronauts in the future. Furthermore, the agency intends to establish a range of ground stations that will function like cell towers on the Moon's surface. The idea is to create a lunar communication system that operates similarly to an internet network rather than a phone line. The relay spacecraft Private companies, including Aquarian Space and Nokia, are contributing to the development of lunar internet infrastructure. Aquarian Space to launch its initial lunar communication satellites by Q2 2025, while Nokia is collaborating with NASA on a 4G cellular network for the Moon. Nokia a contract of over $14 million from NASA and is scheduled to deliver its first base station and radio equipment via a SpaceX rocket next year. plans has won Accurate navigation depends majorly on precise timekeeping as it is crucial in determining the exact location of a . The satnav receiver measures the time it takes for multiple satellite signals to reach it and converts this time measurement into an estimate of distance. satnav receiver Currently, every new expedition to the Moon is conducted on Earth's timeline, with the assistance of deep space antennas to ensure that the spacecraft's clocks are aligned with terrestrial time and to enable communication between the spacecraft and Earth. However, this approach will not be viable in the future lunar environment. There are over planned in the coming decade. These missions will not only occur simultaneously on or around the Moon, but they will also frequently interact with each other. This interaction may involve relaying communications, conducting joint observations, or carrying out rendezvous operations. 250 lunar missions Considering this, space agencies have initiated discussions on how to measure time on the Moon. These discussions began with a meeting at ESA's ESTEC technology center in the Netherlands in November of last year. "During this meeting at ESTEC, we agreed on the importance and urgency of defining a common lunar reference time, which is internationally accepted and towards which all lunar systems and users may refer to. A joint international effort is now being launched towards achieving this,” ESA navigation system engineer Pietro Giordano. said “Timekeeping and time distribution are essential for navigation performance and for maintaining synchronization across multiple assets. Time knowledge significantly impacts observation accuracy. Inaccuracies and differences among sources used in measurement time-tagging impart offsets relative to the true orbit location,”  states the conference paper. Observations commonly used in radio and optometric technologies include one-way and two-way range and Doppler measurements. These observations heavily rely on precise time-stamping, which must be referenced to a standardized time scale such as International Atomic Time (TAI). Establishing a universal lunar time presents a unique challenge as clocks on Earth and the Moon operate at different speeds due to the varying gravitational fields. As such, the form that an official lunar time would take is not clear. One possibility is that lunar time could be based on a clock system that is designed to synchronize with Coordinated Universal Time (UTC). Alternatively, lunar time could be entirely independent of Earth time, resulting in the creation of a unique time system specifically designed for the Moon. According to , a lunar clock would gain approximately 56 microseconds or millionths over 24 hours. The exact rate will be a function of their position on the moon, ticking differently on the lunar surface and orbit. Jeff Gramling's estimation Other than technical standpoints, geopolitics will play a major role in building the lunar economy. The entity that shapes the internet infrastructure on the Moon will wield significant influence, as it will have the authority to establish guidelines for how network providers collaborate and allocate lunar web addresses. Despite the U.S.'s efforts to bring other nations and space agencies into alignment with its , a set of international principles aimed at guiding lunar and outer space exploration and development, there is no assurance that all parties will agree to its terms. Notably, Russia and China are collaborating on their own . Artemis Accords lunar initiatives For effective collaboration, the international community must agree upon a shared "selenocentric reference frame," similar to the International Terrestrial Reference Frame used on Earth, which allows for accurate measurement of precise distances between points across the Moon. Such customized reference frames are crucial components of modern GNSS (Global Navigation Satellite Systems). Once the scientists are able to move past the challenges, the construction of stations will be open to astronauts’ stay and will be resupplied with periodic Artemis launches. Numerous uncrewed missions will also be in place – each Artemis mission alone will release numerous lunar – and ESA will be putting down its Gateway CubeSats . Argonaut European Large Logistics Lander

The Future on the Moon: How LunaNet and Moon Standard Time will Shape the Lunar Economy

চাঁদের ভবিষ্যত: লুনানেট এবং চাঁদের মানক সময় কীভাবে চন্দ্র অর্থনীতিকে রূপ দেবে

Die Zukunft auf dem Mond: Wie LunaNet und die Mond-Standardzeit die Mondwirtschaft prägen werden

Futuro en la Luna: cómo LunaNet y el horario estándar lunar darán forma a la economía lunar

L'avenir sur la Lune : comment LunaNet et l'heure normale de la Lune façonneront l'économie lunaire

चंद्रमा पर भविष्य: कैसे लूनानेट और चंद्रमा मानक समय चंद्र अर्थव्यवस्था को आकार देंगे

月の未来: LunaNet と月標準時が月の経済をどのように形成するか

달의 미래: LunaNet과 달 표준시가 달 경제를 어떻게 형성할 것인가

Futuro na Lua: como o LunaNet e o horário padrão lunar moldarão a economia lunar

Ay'daki Gelecek: LunaNet ve Ay Standart Saati Ay Ekonomisini Nasıl Şekillendirecek?

Tương lai trên Mặt trăng: LunaNet và Giờ chuẩn Mặt trăng sẽ định hình nền kinh tế Mặt trăng như thế nào

月球上的未来：LunaNet 和月球标准时间将如何塑造月球经济

Engaging to Earn with AdLunam Co-Founder Nadja Bester

Let's extend Google Drive with Apps Script to create a simple add-on, and use CardService for the UI, where we'll select a few spreadsheets and pass them to the next card with navigation. You can find my other blogs on Google Apps Scripts right . here Intro Hi, This is Nibes Khadka, from Khadka's Coding Lounge. I wrote this blog because I find the documentation overwhelming for beginners. It is also very hard to find blogs on google apps scripts. So, hence this beginner-level blog was created to get you started. I believe this blog will give you almost 20% you'll need to finish almost 80% of your projects. Pre-Requisite You'll need knowledge of JavaScript and Access to google drive. I am using apps script ide but if you want to develop in the local environment you'll find this guide helpful. set-up Settings Head over to the , and create a new script file for the project. After that, we'll need to prep our projects as instructed below. dashboard HomePages According to the , there're two types of homepages when you're developing add-ons for drive: and . documentation Contextual Non-Contextual Non-Contextual is an initial display when nothing is happening like the first screen to show after the add-on is clicked. Contextual is the home page/display that shows up once we perform a specific action like selecting files in the drive. For the apps scripts functions to get called in the drive, we'll need to assign those functions to the appropriate triggers for the drive add-on in the manifest( ) file. appsscript.json Homepage Triggers When a user clicks on the add-on icon, homepage triggers method is called upon. This method then looks for a function then calls the specified function in the manifest(appsscript.json) for further operations. drive. Item Selected Trigger For contextual triggers, we'll assign the function in our apps script to in the manifest file. drive.onItemSelectedTrigger OAuth Scopes For the drive add-on to work the user must grant access permission. The list of permissions is known as . Details on drive-specific scopes can be found . We'll need to provide the scopes in the file again as a list with "OAuth scopes". Scopes here appsscript.json Note: If your appsscript.json file is hidden then go to settings, then check the checkbox. Show "appsscript.json" manifest file in the editor Check out the manifest file for this project below. {
 "timeZone": "Asia/Kathmandu",
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8"
  "oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/script.storage",
    "https://www.googleapis.com/auth/drive",
    "https://www.googleapis.com/auth/drive.file",
    "https://www.googleapis.com/auth/drive.addons.metadata.readonly"
  ],
  "addOns": {
    "common": {
      "name": "Drive Extension with Apps Script",
      "logoUrl": "provide image URL to be used as logo",
      "layoutProperties": {
        "primaryColor": "#41f470",
        "secondaryColor": "#ab2699"
      }
    },
    "drive": {
      "homepageTrigger": {
        "runFunction": "onDriveHomePageOpen",
        "enabled": true
      },
      "onItemsSelectedTrigger": {
        "runFunction": "onDriveItemsSelected"
      }
    }
  }
} Using Apps Script to Access Google Drive Now, on the root project folder create two files, and . cards main Assigning Apps Scripts Functions to the Trigger’s main // On homepage trigger function
let onDriveHomePageOpen = () => homepageCard();

// On Item selected Trigger function
let onDriveItemsSelected = (e) => itemSelectedCard(e); The and are two functions we assigned in the manifest file earlier on. These functions are in turn calling other functions which we'll create in a while. If you get an error pop-up on saving the file, dismiss it for now. onDriveHomePageOpen onDriveItemsSelected Designing Behaviour of Cards Let's create a simple homepage card to be assigned to our non-contextual trigger on the file. cards Create Homepage Card let homepageCard = () => {
// Create a card with a header section
  let card = CardService.newCardBuilder().setHeader(CardService.newCardHeader());
// create card section 
  let section = CardService.newCardSection();

// add heading 
  let decoratedText = CardService.newDecoratedText()
    .setText("Select Files To Update");

// add text as a widget to the card section
  section.addWidget(decoratedText);

// add the section to the card 
  card.addSection(section);

// return card as build
  return card.build();

} can be used to for the add-ons for google drive. Cards create UI This is a beginners blog so I am not focused on styling. Create Non-Contextual Card Now, let's have another card that we'll be responsible for the contextual trigger on the same file. But let's divide this code into sections to understand it clearly. 1. Create a simple card UI. let itemSelectedCard = (e) => {

  // Initial UI
  let card = CardService.newCardBuilder().setHeader(CardService.newCardHeader().setTitle("Select Sheets Update Master Sheet"));
  let filesSection = CardService.newCardSection()
  filesSection.setHeader("Selected Files");
  return card.build();
} 2. Display Selected files in UI. let itemSelectedCard = (e) => {

  // Initial UI
  let card = CardService.newCardBuilder().setHeader(CardService.newCardHeader().setTitle("Select Sheets Update Master Sheet"));
  let filesSection = CardService.newCardSection()
  filesSection.setHeader("Selected Files");

 // New Code starts here 

// # 1
// Create new array to hold selected files data
  let selectedSheets = [];

// #2
// Fetch selected files data from drive through event objects
  if (e.drive.selectedItems.length > 0) {

    // Selected spreadsheets
// #3
// Among the selected items we'll be selecting only spreadsheets and push them to selected sheets
    e.drive.selectedItems.forEach(item => {
      if (item.mimeType === "application/vnd.google-apps.spreadsheet")
        selectedSheets.push(item)
    }
    );
  }

  // Create a counter to count the number of widgets added
// #4
// COunter is required to prevent error when pushing the file names into UI incase array is empty
  let widgetCounter = 0;

  for (let i = 0; i < selectedSheets.length; i++) {
    // #5
    // Create decorated text with selected files and 
    // add the decorated text to the card section
    filesSection.addWidget(CardService.newDecoratedText()
      //.setText(selectedSheets[i].title)
      .setText(e.drive.selectedItems[0].title)

    );

 // Increase widget counter per loop
 // #4
    widgetCounter += 1;
  }

  // #6
  // Add files as widgets only if widgetCounter is 1+
  //  It prevent error in case only non-spreadsheet files are selected 
  if (widgetCounter >= 1) {
    card.addSection(filesSection)
 }

  // Create Another card that has files list 
  return card.build();
} Here(see the code for numbering like #1), Created an array to hold data on selected items. Used to fetch data on selected files. drive event object Among the selected items we filtered only spreadsheets using . mimeType We created a counter to use as a condition while adding the files as widgets in the card to prevent errors. Created a , a , which will hold the file names of each file. decorated text widget Now finally added the whole files section to the card builder. Generate Actions With Button In Card, interactivity is possible with . Also, check out this . Don't forget to add the scope given there, to drive the scope in your manifest file. actions sample code Let's add buttons below the files section. This button will collect selected files and pass them to another card which we'll build later on. To less complicate things, I'll break down code into smaller sections. 1. Create Button Ui with Action let nxtButtonSection = CardService.newCardSection();
  let nxtButtonAction = CardService.newAction()
    .setFunctionName("handleNextButtonClick"); You've noticed that has been assigned as the function to be triggered on button click. It will handle the navigation, and points toward the next card. We'll create this function later on. handleNextButtonClick 2. Assign Parameters to be passed. // We'll pass only pass ids of files to the next card so that we can fetch them there with id
// #1
  let selectedSheetsIDAsStr = selectedSheets.map(item => item.id).join();

// pass the values as params
// #2
  nxtButtonAction.setParameters({
    "nextCard": "nextCard",
    "selectedSheetsIDAsStr": selectedSheetsIDAsStr,
  });

// add button to the button set 
// #3
  let nxtButton = CardService.newTextButton().setText("Next").setOnClickAction(nxtButtonAction);
  let nxtButtonSet = CardService.newButtonSet().addButton(nxtButton); In the card, parameters need to be passed via action with set parameters method as objects(#2). (hence #1). Buttons can be added as a in the card(#3). It's important to remember that both keys and values should be a string button set You've noticed that has been assigned as a parameter. That's because the function handleNextButtonClick is a general function that takes the name of the card as a parameter instead of hardcoding. This way it will be more efficient in the long run. nextCard Add Button To Card //  It prevent error in case only non-spreadsheet files are selected 
  if (widgetCounter >= 1) {
    card.addSection(filesSection)

    // new line
    nxtButtonSection.addWidget(nxtButtonSet);
    card.addSection(nxtButtonSection);
  } Card Navigation From what I understood , in short, takes a list of cards as a stack. A new card to navigate to is added to the top of the stack, which popped from the stack to return to the previous one. card navigation Let's create a new file, I'll name it , and add the following instructions. helpers helpers /* This is a greneral nav function
You use it with card action and as a response, it will supply card functions from cardsInventory */
let handleNextButtonClick = (e) => {

// #1
// Extract string nextCard to pass it as key in cards inventory obj
  let nxtCard = cardsInventory[e.commonEventObject.parameters.nextCard];

  // #2
  // Convert String into List of files selected by the user
  let selectFilesIdList = e.commonEventObject.parameters['selectedSheetsIDAsStr'].split(",");

// #3
// use actionResponse to create a navigation route to the next card
  let nxtActionResponse = CardService.newActionResponseBuilder()
    .setNavigation(CardService.newNavigation().pushCard(nxtCard(selectFilesIdList))) // #4, Passing the mastersheet with params
    .setStateChanged(true)
    .build();

  return nxtActionResponse;
}


/**
 *  Create a dictionary that
 is consist of cards for navigation with appropriate keys  
 */

var cardsInventory = {
  'nextCard': nextCard
} Let's first talk about the object.  If you remember we passed the parameter previously as a string in the function. This nextCard is the function we'll create next. But the thing is you can't pass a string and use it to reference a variable(check #1 in the code). So, we're creating a dictionary that'll match appropriate keys with functions for navigation. card inventory nextCard itemSelectedCard Inside handleNextButtonClick function: Extract the string which is key to the cardInventory object to fetch the correct card to call. We're using to extract parameters passed on earlier. Events Comment Object The string that was passed as selected files id's, we're again converting to the array. combined are used to set a new to the card of our choosing. NewActionResponseBuilder, SetNavigation, NewNavigation, and PushCard path Here, we're passing a list of ids as params. Next Card To Navigate We'll create a very simple card just enough to display the list of IDs, to let us know our code is working. First, let's create a new file . next_card var nextCard = function (lst) {

  let cardService = CardService.newCardBuilder().setHeader(CardService.newCardHeader().setTitle("Select Master Sheet To Update"));

  let filesSection = CardService.newCardSection();

  filesSection.setHeader("Selected Files");

  let widgetCounter = 0;

  let selectedFilesList = [...lst];

  selectedFilesList.forEach(id => {
    filesSection.addWidget(CardService.newDecoratedText()
      .setText(id));
    widgetCounter += 1;
  });

  if (widgetCounter >= 1) {
    cardService.addSection(filesSection);
  }


  return cardService.build();
} The only thing new to notice here is that I am not using es6 syntax to declare a function. That's because using it caused a scoping issue and the error, . Hence, I went to the old school with . the function is not defined var Publish Add-On in GCP for Testing To publish an add-on to the GCP follow these two instructions here. Create a standard . GCP project Integrate a project with an . apps script project Final Code cards let itemSelectedCard = (e) => {

  // Initial UI
  let card = CardService.newCardBuilder().setHeader(CardService.newCardHeader().setTitle("Select Sheets Update Master Sheet"));
  let filesSection = CardService.newCardSection()
  filesSection.setHeader("Selected Files");

  let nxtButtonSection = CardService.newCardSection();
  let nxtButtonAction = CardService.newAction()
    .setFunctionName("handleNextButtonClick");
  let selectedSheets = [];

  if (e.drive.selectedItems.length > 0) {
    // hostApp,clientPlatform,drive,commonEventObject
    // Selected spreadsheets
    e.drive.selectedItems.forEach(item => {
      if (item.mimeType === "application/vnd.google-apps.spreadsheet")
        selectedSheets.push(item)
    }
    );
  }

  // Create a counter to count number of widgets added
  let widgetCounter = 0;

  for (let i = 0; i < selectedSheets.length; i++) {
    // Create decorated text with selected files and 
    // add the decorated text to card section
    filesSection.addWidget(CardService.newDecoratedText()
      //.setText(selectedSheets[i].title)
      .setText(e.drive.selectedItems[0].title)

    );
    widgetCounter += 1;
  }


  // Change list of  selected sheet's id  as string to pass to next card 
  let selectedSheetsIDAsStr = selectedSheets.map(item => item.id).join();

  nxtButtonAction.setParameters({
    "nextCard": "nextCard",
    "selectedSheetsIDAsStr": selectedSheetsIDAsStr,
  });

  let nxtButton = CardService.newTextButton().setText("Next").setOnClickAction(nxtButtonAction);
  let nxtButtonSet = CardService.newButtonSet().addButton(nxtButton);


  // Add files and button section only if the widgets are present
  //  It prevent error in case only non-spreadsheet files are selected 
  if (widgetCounter >= 1) {
    card.addSection(filesSection)

    nxtButtonSection.addWidget(nxtButtonSet);
    card.addSection(nxtButtonSection);
  }

  // Create Another card that has files list 
  return card.build();
} helpers /* THis is a greneral nav function
You use it with card action and as reponse it will supply card functions from cardsInventory */
let handleNextButtonClick = (e) => {

  let nextCard = cardsInventory[e.commonEventObject.parameters.nextCard];
  console.log(nextCard)

  // Convert String into List
  let selectFilesIdList = e.commonEventObject.parameters['selectedSheetsIDAsStr'].split(",");

  let nxtActionResponse = CardService.newActionResponseBuilder()
    .setNavigation(CardService.newNavigation().pushCard(nextCard(selectFilesIdList)))
    .setStateChanged(true)
    .build();

  return nxtActionResponse;
}


/**
 *  Create a dictionary that
 is consist of cards for navigation with appropriate keys  
 */

var cardsInventory = {
  'nextCard': nextCard
} Summary Alright, let's recall things we did in the project. Defined appscrits.json files with the appropriate scopes and triggers required for Drive Add-on. Created a simple card UI to interact with users. Fetched selected files from the drive with the apps script. Used Actions and Button Sets to let users interact with our card UI. Created a simple navigation logic to move between two cards. Show Some Support This is Nibesh Khadka from Khadka's Coding Lounge. Find my other blogs on Google Apps Scripts . I am the owner of Khadka's Coding Lounge. We make websites, mobile applications, google add-ons, and valuable tech blogs. . here Hire us!, Like, Share and Subscribe to our newsletter Also Published here

Managing Google Drive with a Google Apps Script and Add-Ons

The Girl’s School is an oval building made of sandstone that stands amid the Thar desert near the city of Rajkumari Ratnavati Jaisalmer, India. The renowned architect Diana Kellogg and her New York-based studio ensured that they honor the local culture and building traditions, while also introducing modern elements to the school. In this Slogging thread, our community discussed about how an oval school in the Thar desert empowers young girls. This Slogging thread is by Valentine Enedah, Janhavi Talhar, Mónica Freitas and Manas Goel occurred in slogging's official #random channel, and has been edited for readability. Valentine Enedah Oct 18, 2022, 2:22 PM This edifice rises from the sand to offer a safe and enjoyable learning environment. https://mashable.com/video/thar-desert-school-female-empowerment-india-diana-kellogg 💚 4 Valentine Enedah Oct 18, 2022, 2:24 PM Some cool features of the ﻿Rajkumari Ratnavati: Photo credit: DK Architects 1. The entire building has an oval shape, which universally symbolizes female strength. And it’s designed in such a way that it will filter out sunlight and maximize airflow around the building. A solar canopy supplies the power for the school, and the courtyard is aimed to harvest almost 3.5 lac litre of rainwater. This work of art blends conventional and contemporary architectural features 2. Ancient rain harvesting techniques ensure the water supply in the building, while electricity is sourced entirely from solar power. The school relies on natural cooling, which Kellogg says has significantly reduced temperatures in the building. 3. The school uniform was created by fashion designer utilizing the local Ajrak block printing technique. . Sabyasachi Mukherjee Photo credit: DK Architects This is brilliant! My first thought of its look reminded me of The Amazonian playground in You need to see that movie. Wonder Woman 1984. What do you think? Janhavi Talhar Oct 19, 2022, 12:35 PM Valentine Enedah Most ancient Indian institutions provided a wide range of disciplines, from law to medicine to astronomy to Buddhist theology, Vedic studies to the Atomic Theory of the World (authors translation) and many others. Since Arab (edit) and Turkic conquerors destroyed Vallabhi, Nalanda, and Viakramasila, knowledge of these institutions is relatively restricted. The Vedas and Upanishads, which teach science, politics, and philosophies during the various historical periods in which they were written, still provide access to the majority of the concepts and theories. Looking at these scriptures and other details, we can see that several modern education concepts (Jyotish, Ayurveda, Tantra, etc.) were taught in a slightly different way here, the architectural beauty is also detailed and well laid out, the political system (Chanakya neeti) was also well established, and there are so many small details that can be studied. 💚 1 Mónica Freitas Oct 19, 2022, 4:46 PM I love this! It's so utopic, and modern. It's what society should aspire to turn and, construction wise, it's so smart and ecological. AMAZING 💚 1 Manas Goel Oct 19, 2022, 5:06 PM What a marvel! Being from India myself, I would definitely visit this school! India being a tropical country experiences extreme weathers! and natural cooling is a very useful facet too! Amazed and Proud!🙌 💚 1 Valentine Enedah Oct 20, 2022, 8:21 AM Janhavi Talhar Indeed! I feel India has so many historic buildings and on top of that so many great scholars have Indian origins. Valentine Enedah Oct 20, 2022, 8:25 AM Mónica Freitas You have a great point. I doubt urban areas would want something like that. They could call it Archaic. But if they leverage technology to it's core, I know for sure, this school will one to remember. Valentine Enedah Oct 20, 2022, 8:26 AM Manas Goel That's so amazing. I would love to know about your experience after you have visited. Pictures would help as well😁 💚 1 Mónica Freitas Oct 26, 2022, 11:57 AM Valentine Enedah I don't see how people could call this archaic. Granted I live in a country with a lot of old structures, so this would be so fun to witness and experience. I'm sure the structure would have to be adapted to the climate but it'd create more specialised professionals too 💚 1 Valentine Enedah Oct 26, 2022, 1:30 PM Mónica Freitas I totally agree with your perspective. It will strive in some places no doubt due to its uniqueness. Mónica Freitas Oct 27, 2022, 10:27 AM Valentine Enedah it'll demand that we change the way we do things, probably take more time to build, and maybe face a bit of resistance from governments or businesses but I'm hoping we can scale it Valentine Enedah Oct 27, 2022, 12:24 PM Mónica Freitas Definitely! I think we need amazing people like you to pioneer or anchor these projects. 'Wonder woman saves the system of education in underrepresented communities.' Mónica Freitas Oct 31, 2022, 3:45 PM Valentine Enedah my dad works in construction. Don't give him any ideas 😂 😂 1 Valentine Enedah Oct 31, 2022, 5:42 PM Mónica Freitas You should tell him.🙂 Female empowerment through education and play stands at the centre of this school. These values inform her work on all levels, from researching and applying the symbolism of the elliptical shape, to the incorporation of jali walls and modesty screens where the girls can play.

The Rajkumari Ratnavati Girl’s School: An innovative,safe and playful study environment.

461 Stories To Learn About Slogging

111 Stories To Learn About Architecture

KNOWLEDGE SATNAV

knowledgesatnav.com

-- employees

Since n.d.

COMPANY RANKING

KNOWLEDGE SATNAV

EVERGREEN INDEX #6365

Representing this company? Click here to claim and customize this page!

Knowledge Satnav WIKI

Apply to get your Tech Company News Page live on HackerNoon.com today!

KNOWLEDGE SATNAV

knowledgesatnav.com

-- employees

Since n.d.

COMPANY RANKING

KNOWLEDGE SATNAV

EVERGREEN INDEX #6365

RELATED COMPANIESRANK

STORIES ABOUT KNOWLEDGE SATNAV

Representing this company? Click here to claim and customize this page!

Knowledge Satnav WIKI

Apply to get your Tech Company News Page live on HackerNoon.com today!