ContributionsMost RecentMost LikesSolutionsRe: Button to save and go to the next record in edit modeThis is how to save and redisplay the current record in edit mode. I need a save and display NEXT record in edit mode.Button to save and go to the next record in edit modeI need to create a button that will work in the mobile app that will save the current record and then go to the next record in edit mode. The button is available in web view as "Save and Next." I need that same functionality in the mobile app. any help is appreciated.Re: Remove duplicates from Concatenated Child to Parent Field - Involves JavascriptWorked great! Thanks so much!! One other question, no big deal if no easy solution for this but is there a way to get the data from that field to show up on an e-mailed report? For some reason that field comes over blank when I try to e-mail. I added a formula text field and converted it to text but that didn't do the trick.Re: Remove duplicates from Concatenated Child to Parent Field - Involves JavascriptI basically copied the formula i'm using exactly as is. Is it possible you could tell me exactly where exactly this new addition might go within my formula? Sorry for being such a novice. :)Re: Remove duplicates from Concatenated Child to Parent Field - Involves JavascriptOh and I'd also like the result to be sorted A-ZRemove duplicates from Concatenated Child to Parent Field - Involves JavascriptI have a field that is using Dan Diebolt's IOL technique that is Concatenating child fields to the parent record into one combined field. I would like for this field to remove all duplicates and blanks. Can someone please help? Field 173 that is being combined might say the same thing in each record so it is repeating in my combined field and I want it to only be listed once. Field 173 may also be blank and I do not want the blank spaces in the combined field. I appreciate any help! Thank you! Here is the code I am using: (function(){ var XMLFlatToObj = function(xml, type) { var data = []; var record = {}; $("record", xml).each(function() { record = {}; $(this).children().each(function () { record[$(this).prop("tagName")] = $(this).text(); }); data.push(record); }); return {records: data}; } var dbid = "bjvehdwbq"; var dbidParents = "bjvehdwcb"; var dbidChilds = "bjvehdwcj"; var apptoken = "d5ju6zccf9kf3bdbi87gsj8yz8m"; $.ajaxSetup({data: {apptoken: apptoken}}); var rids = $("span.QBU_Childs").map(function() { return this.dataset.rid; }).get(); var n= 100; var ridsChunked = _.chain(rids).groupBy(function(element, index){ return Math.floor(index/n); }).toArray().value(); _.each(ridsChunked, function(rids, index) { var query = "{22.EX." + rids.join("}OR{22.EX.") + "}" $.ajax({ url: dbidChilds, data: { act: "API_DoQuery", clist: "3.22.173", query: query }, dataFilter: XMLFlatToObj }).then(function(resp) { var childsData = _.groupBy(resp.records, function(items) { return items["related_lot"]; }); _.each(childsData, function(item, rid) { $("span.QBU_Childs[data-rid=" + rid + "]").html( _.pluck(item, "combined_defects").join("<span style='color:red;'> | </span>") ); }); }); }); })();Re: How to use JavaScript to concat child records into a single field?Hi Dan, or whoever else can help. I've been trying to get this to work and all I'm getting are the listed dots. So it's giving me the correct total number of dots for the exact total number of records but it is not returning the field values. Any suggestions on what we could be doing wrong?Re: How can one convert a ""Date/Time"" value to a ""Date Only"" value?What field type do I use for this formula?Formula Text, Formula Date, Formula Date/Time, etc.?Re: How do I create a button on a form that will save the current record, copy some of the fields to a new record, and redisplay the new record in edit mode?I don't know about being a whiz but I'm atleast at novice level now! I found the correct reference field and it's now working. Thank you for your help!Re: How do I create a button on a form that will save the current record, copy some of the fields to a new record, and redisplay the new record in edit mode?Thank you!I'm almost there..... I'm running into one problem.I went with the high tech scenario option 1 - here is my formula: URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm" & "&_fid_85=" & URLEncode([PO # (on PO form) - Lookup]) & "&_fid_23=" & URLEncode([Item Number (on ITEMS form) - Lookup]) & "&_fid_6=" & [Inspector] Field 23 is not populating.It's a look up field that relates the inspection back to the item being inspected.Any idea why that isn't populating?FID 85 is also a look up field and that one is populating correctly.Could it have something to do with the relationship between those 2 fields?