ContributionsMost RecentMost LikesSolutionsRe: Automation not copying recordsThanks for this Mark. Is there any way I can set what time the automation can run?Automation not copying recordsI 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 requestHi 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 look Re: Using webhook to trigger API get requestSo im stuck on this, is there anyone that can assist here? this code of Dans is not working. Any help is appreciated. Re: Convert comma separated values to new child recordsSo i tried it and nothing gets posted. Not sure whyRe: Convert comma separated values to new child recordsHi Dan. So i go the formula and output to work perfectly, but the webhook doesnt seem to be working. I have tried everything, but no luck. Am i missing something? Re: Convert comma separated values to new child recordsThanks this does. I'll give it a crack... You guys have been a great help thank youRe: Convert comma separated values to new child recordsThanks Mark. I'll give it a goRe: Convert comma separated values to new child recordsok, im getting a better understanding of this. I've never done a webhook such as this. Is there any example you may have? Re: Convert comma separated values to new child recordsHi 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