ContributionsMost RecentMost LikesSolutionsRe: .JS with iol Won't work anymorethe console only says "null" but in debugging it highlighted "console.dir(json);". By the way, this is the illustration of what this js. does for us in a smaller scale, just disregard the field name Table 1 (this is the source table) Letter Number Color shapes Qty a 1 black circle 1 b 2 white yellow square 1 c 1 green circle 1 d 2 green square 1 a 1 orange square 1 b 2 black square 1 c 1 white yellow square 1 d 2 green square 1 a 1 green square 1 b 2 orange square 1 c 1 black circle 1 d 2 white yellow circle 1 a 1 green square 1 b 2 green triangle 1 c 1 orange circle 1 d 2 green circle 1 It groups it by variation and summarize it into xml, (notice the variation a-1-green-square has total quantity of 2) Letter Number Color shapes Total Qty a 1 black circle 1 a 1 green square 2 a 1 orange square 1 b 2 black square 1 b 2 green triangle 1 b 2 orange square 1 b 2 white yellow square 1 c 1 black circle 1 c 1 green circle 1 c 1 orange circle 1 c 1 white yellow square 1 d 2 green circle 1 d 2 green square 2 d 2 white yellow circle 1 Then it imports it to Table no2 - here should be the result of the destination table. Letter Number Color shapes Total Qty a 1 black circle 1 a 1 green square 2 a 1 orange square 1 b 2 black square 1 b 2 green triangle 1 b 2 orange square 1 b 2 white yellow square 1 c 1 black circle 1 c 1 green circle 1 c 1 orange circle 1 c 1 white yellow square 1 d 2 green circle 1 d 2 green square 2 d 2 white yellow circle 1 Please let us know if there's any other way to accomplish this. We really appreciates your help, Roel ------------------------------ Roel David ------------------------------ Re: .JS with iol Won't work anymoreWe have 3 .js pages like these that uses the a "Button Formula" like this: "<a class=\"Vibrant Success\" onclick=\"$.getScript(gReqAppDBID+'?a=dbpage^pagename=" & "Tabletmodulev43.js"& "');return false;\">" &"FINALIZE"& "</a>" The function of the page "Tabletmodulev43.js" is to import a summary of one table to another table by logging it first to console log and creating an XML object then importing it to a table: We did this because Quickbase only does table to table import and doesn't have this feature. What we are really needed is TableSummary to Table import. Let me know if there some other way to do this other than Javascript. (function() { var XMLStructuredToObj = function(xml, type) { var fidToLabel = {}; $("field", xml).each(function() { var id = $(this).attr("id"); var label = $("label", this).text(); //console.log(id, label); fidToLabel[id] = label; }); var data = []; var record = {}; $("record", xml).each(function() { record = {}; $("f", this).each(function() { record[fidToLabel[$(this).attr("id")]] = $(this).text(); }); data.push(record); }); return {records: data}; }; var dbid = "bkuuybf9b"; var dbidAssetID = "bmuq9d5dj"; var dbidItemDetails = "bpb3hui78"; var apptoken ="t8gsgdut8g28cw2fw7fbek3vw9"; $.ajaxSetup({data: {apptoken: apptoken}}); $.ajax({ url: dbidAssetID, data: { act: "API_DoQuery", query: "{33.EX._fid_19}", clist: "23.6.19.29.31.30.26", slist: "23.6.19.29.31.30.26", fmt: "structured" }, dataFilter: XMLStructuredToObj }).then(function(json) { console.dir(json); var groups = _.groupBy(json.records, function(record) { return record["Related Model Numbers"] + "|" + record["V43 - Tier"] + "|" +record["Related Purchase Order / Service Program"] + "|" +record["Asset ID - Item Detail - Related Manufacturer"]+ "|" +record["Asset ID - Item Detail - Related PN ID"]+ "|" +record["Asset ID - Item Detail - Type"]+ "|" +record["Tablet Triage Summary ID"]; }); var csv = _.map(groups, function(item, key) { return '"' + (key + "|" + item.length).split("|").join('","') + '"'; }); console.log(csv.join("\n")); $.post(dbidItemDetails, { act: "API_ImportFromCSV", clist: "6.7.8.9.10.11.12.13", records_csv: csv.join("\n") }).then(function(xml) { console.dirxml(xml); document.location. Thank you, ------------------------------ Roel David ------------------------------ .JS with iol Won't work anymoreHi, We are using .js with iol as a part of our application. Now, it doesn't work anymore. This is a huge part of our application feature that automates our entire system. under our pages"Tabletmodulev43.js" here is our code (function() { var XMLStructuredToObj = function(xml, type) { var fidToLabel = {}; $("field", xml).each(function() { var id = $(this).attr("id"); var label = $("label", this).text(); //console.log(id, label); fidToLabel[id] = label; }); var data = []; var record = {}; $("record", xml).each(function() { record = {}; $("f", this).each(function() { record[fidToLabel[$(this).attr("id")]] = $(this).text(); }); data.push(record); }); return {records: data}; }; var dbid = "bkuuybf9b"; var dbidAssetID = "bmuq9d5dj"; var dbidItemDetails = "bpb3hui78"; var apptoken ="t8gsgdut8g28cw2fw7fbek3vw9"; $.ajaxSetup({data: {apptoken: apptoken}}); $.ajax({ url: dbidAssetID, data: { act: "API_DoQuery", query: "{33.EX._fid_19}", clist: "23.6.19.29.31.30.26", slist: "23.6.19.29.31.30.26", fmt: "structured" }, dataFilter: XMLStructuredToObj }).then(function(json) { console.dir(json); var groups = _.groupBy(json.records, function(record) { return record["Related Model Numbers"] + "|" + record["V43 - Tier"] + "|" +record["Related Purchase Order / Service Program"] + "|" +record["Asset ID - Item Detail - Related Manufacturer"]+ "|" +record["Asset ID - Item Detail - Related PN ID"]+ "|" +record["Asset ID - Item Detail - Type"]+ "|" +record["Tablet Triage Summary ID"]; }); var csv = _.map(groups, function(item, key) { return '"' + (key + "|" + item.length).split("|").join('","') + '"'; }); console.log(csv.join("\n")); $.post(dbidItemDetails, { act: "API_ImportFromCSV", clist: "6.7.8.9.10.11.12.13", records_csv: csv.join("\n") }).then(function(xml) { console.dirxml(xml); document.location.href = "https://tiercycle.quickbase.com/db/bkuuybgji?act=API_RUNIMPORT&id=34&rdr=https%3A%2F%2Ftiercycle.quickbase.com%2Fdb%2Fbkuuybgrq%3Fact%3DAPI_RUNIMPORT%26id%3D16%26rdr%3Dhttps%253A%252F%252Ftiercycle.quickbase.com%252Fdb%252Fbkuz74av2%253Fact%253DAPI_RUNIMPORT%2526id%253D48%2526rdr%253Dhttps%25253A%25252F%25252Ftiercycle.quickbase.com%25252Fdb%25252Fbkuuybgji%25253Fact%25253DAPI_PurgeRecords%252526qid%25253D103%252526rdr%25253Dhttps%2525253A%2525252F%2525252Ftiercycle.quickbase.com%2525252Fdb%2525252Fbkuuybgrq%2525253Fact%2525253DAPI_PurgeRecords%25252526qid%2525253D14%25252526rdr%2525253Dhttps%252525253A%252525252F%252525252Ftiercycle.quickbase.com%252525252Fdb%252525252Fbpb3hui78%252525253Fact%252525253DAPI_PurgeRecords%2525252526qid%252525253D1%2525252526rdr%252525253Dhttps%25252525253A%25252525252F%25252525252Ftiercycle.quickbase.com%25252525252Fdb%25252525252Fbkwue297z%25252525253Fa%25252525253Dq%252525252526qid%25252525253D19"; }); }); })(); We really appreciate if you can help us on this, ------------------------------ Roel David ------------------------------ Display Latest Record in the Cross Tab SummaryI have a report that cross Tab summarize the quote of my Suppliers. However, it only displays the minimum or maximum quote. I would like for it to display the latest quote. How can I do this?