CarlosCarlos
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
- 28Views0likes0Comments
Re: 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!67Views0likes0CommentsAuto 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.78Views1like2CommentsChange 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 nothing
Carriage return works with encodeURIComponent( "\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..4Views0likes0CommentsRe: API_ImportfromCSV doing nothing
Hi 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.6Views0likes0CommentsAPI_ImportfromCSV doing nothing
Hi 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!