const FORM_URL = 'YOUR_FORM_EDIT_URL';
const form = FormApp.openByUrl(FORM_URL);
const ss = SpreadsheetApp.getActiveSpreadsheet();
const optionsSheet = ss.getSheetByName('Options');
const data = optionsSheet.getDataRange().getValues().slice(1); // Skip header
// Reset form
form.getItems().forEach(item => form.deleteItem(item));
// Create country question
let countryQuestion = form.addMultipleChoiceItem().setTitle('Country');
let countries = [...new Set(data.map(row => row[0]))]; // Unique countries
let countryChoices = [];
// Loop for sections and cities
countries.forEach(country => {
let section = form.addPageBreakItem().setTitle(country);
section.setGoToPage(FormApp.PageNavigationType.SUBMIT);
let cityData = data.filter(row => row[0] === country).map(row => row[1]);
let cityQuestion = form.addMultipleChoiceItem().setTitle('City');
cityQuestion.setChoices(cityData.map(city => cityQuestion.createChoice(city)));
countryChoices.push(countryQuestion.createChoice(country, section));
});
countryQuestion.setChoices(countryChoices);
SDG 2 - 0 hunger not achived
SDG 2 – Zero Hunger Status SDG 2 (Zero Hunger): Most Off-Track Goal SDG 2 is currently the most off-track of all 17 Sustainable Development Goals, with global hunger rising and food insecurity worsening across regions. ЁЯЪи SDG 2: The Most Troubled Goal Over 2.33 billion people faced moderate or severe food insecurity in 2023. Hunger affected 9.1% of the global population. Sub-Saharan Africa: 23.2% affected Southern Asia: 281 million people affected Global food systems remain fragile due to conflict, climate change, inflation, and supply chain shocks. Challenges Despite Progress in Other SDGs Insufficient investment in smallholder agriculture Rising food prices and affordability gaps Climate-related crop failures and water scarcity Lack of integrated nutrition and food access policies ЁЯУЙ Other SDGs Also Struggling SDG 4 (Quality Education): 57% of targets show no progress or are regre...
Comments
Post a Comment