मैं चाहता हूँ करने के लिए समूह के लोगों द्वारा वे राज्य में रह रहे हैं. मैं कैसे कर सकते हैं कि का उपयोग कर गूगल app स्क्रिप्ट? मैं के बारे में सोचा का उपयोग कर एक forEach पाश उन्हें समूह के लिए, लेकिन नहीं भी यकीन है कि जो दिशा का वहाँ से जाने के लिए. दर्ज की छवि विवरण यहाँ
1
function sortByState() {
const sA = ["AL","AK","AS","AZ","AR","CA","CO","CT","DE","DC","FL","GA","GU","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","MP","OH","OK","OR","PA","PR","RI","SC","SD","TN","TX","UT","VT","VA","VI","WA","WV","WI","WY"];
const ss = SpreadsheetApp.getActive();
const sh = ss.getActiveSheet();
const hA = sh.getRange(1, 1, 1, sh.getLastColumn()).getValues()[0];
let idx = {};
hA.forEach((h, i) => { idx[h] = i; });
const rg = sh.getRange(2, 1, sh.getLastRow() - 1, sh.getLastColumn());
const vs = rg.getValues().sort((a,b) => {
vA = sA.indexOf(a[idx['State']]);
vB = sA.indexOf(b[idx['State']]);
return vA - vB;
});
rg.clearContent();
sh.getRange(2,1,vs.length,vs[0].length).setValues(vs);
}