ContributionsMost RecentMost LikesSolutionsRe: How To Dialog?Yeah no issues. Shoot me an email if you like.Re: How To Dialog?Works greatRe: Auto SUM cost of items in an invoice (child records)That could work, but we wanted to avoid having to have a page refresh (sales guys are on ipads and load times sometimes are slow, depending on wifi coverage). I would appreciate the Update Total Price button though, I'll propose it as a solution! Thanks!Auto SUM cost of items in an invoice (child records)So I have an app that is being used to build a quote for vehicles. Initially the accessory options were added as check boxes and they would relate to a formula-numeric field that would add the cost of each selected. This is now un-sustainable, as accessories change price often, so I built 2 new tables: Accesory (Master) holds the information of all accessories currently offered (Item ID, Name, Description, Img, Price, etc.) Added Accessories is related to both the quote and the Accessory (Master) table, and holds the price using a snapshot field. Is there a way that when I am building a new Quote, and haven't saved it yet, I can see the total value of added accessories? I'm using a Grid-Edit to add child records to the quote, but need to have the total price of accessories in order to validate whether it will need management approval or if the salesman can just print & submit.Re: Change XML report format, is it possible?I did but I actually need a certain different format, like changing the "<record>" tags to another name, and removing some of the header tags.. Change XML report format, is it possible?I have a provider that is looking to query our Database and pull an XML file, but they're requiring that it is generated in a specific format (very similar to the current, standard, XML output of reports but with certain variations). Is it possible to generate an XML file with a different format that can be accessed and downloaded? I was thinking using something like Exact Forms, but would appreciate any help.Re: API_ImportfromCSV doing nothingCarriage return works withencodeURIComponent("\r\n") _on the URL. However, I still can't get it to work pasing the array. Tried using var cdata = XmlService.createCdata(csvString); With the csvString ='<![CDATA[' + csvString + ']]>' csvString contains the numbers separated by \r\n as described above..Re: API_ImportfromCSV doing nothingWell that seems to have done the trick nicely!! I'd like to get it to work without using the URL alternative, basically so an unlimited number of records could be posted at any given time, but this will definitely do for now! Thanks a lot!Re: API_ImportfromCSV doing nothingHi Chayce, I actually have a single column (Guia) that is being imported, and the 2 values there (34168 and 102999) are 2 records that should be created, importing into fid_6. Though currently only 2 values/new records, this could be any number of records, but always a single value will create them. The array would look something like [34168,102999] with N number of values possibly in there. I'm manually adding the "Guia" header, though that could be removed.API_ImportfromCSV doing nothingHi all! I'm trying to run this API_ImportfromCSV but it's getting me nowhere. I'd appreciate some help as I've been stuck with it for many hours, and haven't gotten to my error. https://(DOMAIN).quickbase.com/db/(TABLE)?a=API_ImportFromCSV&usertoken=(USERTOKEN)&apptoken=(APPTOKEN)&records_csv=Guia,34168,102999&clist=6&skipfirst=1 This should create new records in the table when the API is run. Added "apptoken" as the API returned an error even when using usertokens. Everything seems to be fine, but the reply is: <qdbapi> <action>API_ImportFromCSV</action> <errcode>0</errcode> <errtext>No error</errtext> <num_recs_input>0</num_recs_input> <num_recs_added>0</num_recs_added> <num_recs_updated>0</num_recs_updated> <num_recs_unchanged>0</num_recs_unchanged> </qdbapi> Nothing seems to happen! I've tried doing this from google scripts, as I want to automate the import but this also doesn't seem to work.. I have the values I need for the CSV in an array, which i'm joining using var csvString = "Guia," + arregloGuias.join(",\n"); var url = baseURL + table + "?a=API_ImportFromCSV" + usr_token + apptoken; var options = { "method" : "POST", "records_csv" : csvString, "clist" : "6", "skipfirst": "1" }; Logger.log(url + options); var result = UrlFetchApp.fetch(url, options); Logger.log(result); The result is the same <?xml version="1.0" ?> <qdbapi> <action>API_ImportFromCSV</action> <errcode>0</errcode> <errtext>No error</errtext> <num_recs_input>0</num_recs_input> <num_recs_added>0</num_recs_added> </qdbapi> Appreciate any help!! Thanks!