GeoffreyHarmuth
Qrew Captain
Joined 7 years ago
User Profile
User Widgets
Contributions
Automation not copying records
I have 2 tables; Table 1: Products (about 500 records) Table 2: Daily product valuations This is what I am trying to accomplish: 1) Copy all the products from table 1 to table 2, every day at a scheduled time. 2) Fields to copy are: Description, cost, quantity on hand. 3) This will allow me to get a snap shot of each stock item and its quantities/cost every day. 4) I can then create a summary report in this "Daily products valuation table" to pin point the stock values and quantities at any given day. The problem: I am trying an automation: but, an automation doesn't seem to be working (it runs, but no records are copied). Does this have something to do with the 10 records a second rule? Is the use of an automation not going to work? or is there a more novel solution to this?Re: Using webhook to trigger API get request
Hi Austin. Thanks, my post was just to check if someone is able to assist on this since Dan is MIA. So the first line of code (Jquery) doesn't seem to work, i'm not sure if there is a syntax error. I tested in the console first. Secondly, i'm not sure how to combine the 2 pieces of code (below) To pull the information and add into the quickbase native address type field.: First one to fetch the info: var apikey = "YOUR API KEY"; var addr = "puns.chew.snow"; var url = 'https://api.what3words.com/v2/forward?addr=${addr}&display=full&format=json&key=${apikey...; $.get(url) .then(function(json) { console.log(json.geometry.lat); console.log(json.geometry.lng); console.log(json.map); console.log(JSON.stringify(json, null, " ")); }); And second to populate the field forms: _fid_7.value = json.geometry.lat; _fid_8.value = json.geometry.lng; _fid_9.value = json.map; I am thinking I should run the code in a formula url button, and making the script as follows: var apikey = "YOUR API KEY"; var addr = [what3words address field]; var url = 'https://api.what3words.com/v2/forward?addr=${addr}&display=full&format=json&key=${apikey...; $.get(url) .then(function(json) { _fid_7.value = json.geometry.lat; _fid_8.value = json.geometry.lng; _fid_9.value = json.map; console.log(JSON.stringify(json, null, " ")); }); But im messing the code up somewhere (not a developer here). I would like for the script to run automatically using iol, but im not entirely sure how the script page would need to lookRe: Convert comma separated values to new child records
Hi Mark. Is there any way i can get this to work without doing automation? I dont want to go and add another 60 odd fields just to cater for the unknown limitation of items being added. I like Dans idea, but it exceeds my current skill level to implement. Dont mind working off line if you feel its too complicated to post here. Will appreciate the help
