ContributionsMost RecentMost LikesSolutionsRe: How to break up address field into sub fields in chUgh. What a pain but thanks. That's the ticket.How to break up address field into sub fields in chI have an address field that is passed from parent to child. Once the lookup field is an "Address" type, I am having trouble figuring out how to break it into the component sub fields? It seems like the Field IDs are located on the original Field Settings page on the table where the address field was originally created, but I don't see how that sub-field-information moves as the record is passed to child records? Update records in Sync TableI have a sync table with Field 1 as "Refresh Update Key" in the sync and a different Field 2 as the Key Field. I need to correct a bad record in the table, by changing the value of Field 2 with a particular field 1 value. But When I sync the new record, quickbase says it syncs OK, but the record doesn't actually update. Is this possible?Re: Webhook or action to create parent record on child importThanks. So Manual it is until I get frustrated enough to get a script written. Thanks for the education :)Re: Webhook or action to create parent record on child importIt seems as though webhooks/actions should be able to either a) add the record or b) update if it already exists?Re: Webhook or action to create parent record on child importso the same error occurred.Re: Webhook or action to create parent record on child importIT seems that it checks the criteria one time then ran the entire thing instead of each time it was going to add a record..Re: Webhook or action to create parent record on child importWhen order line is added, then add a record to the parent table. Values: Copy the value from "Order Number MOS" which is a formula field that holds the order number to "Master Order Number" which is the Key Field of the parent table. In my test data, I through error 51. because I had two lines that had the same order number (because an order can have multiple lines). I was hoping it would just overwrite the new record...but I think Add has to be unique.?Webhook or action to create parent record on child importWe have a temporary app where order records (line items) are imported into a table. I am trying to use an action/webhook (since I can't program Javascript) to create the parent record so that I can create summaries of records that meet certain requirements. Summary Tables are somewhat helpful, but are showing great limitations in what I'm trying to accomplish. I tried an action to create a record but got an error stating I was using non-unique values...I thought after it added the first record via the action it would simply update it if the second line had the same record ID. Instead it threw an error. (API_ImportFromCSV) If you use update record instead of import or add and the record ID doesn't exist will it create it?Re: UPC code (12 digit text field) being converted to Scientific Notation in ExcelFunny. When you open it in Excel it shows this ==>'897757002605 but if you delete the ' and then re-add it the ' disappears. :(I think once the file is CSV it's all up to excel how it's going to read it. Frustrating that Microsoft hasn't fixed this annoying behavior. Pushgin to Scientific notation as a default is just DUMB and could at least a a choice in the Preferences.