StephenStephen
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
How to break up address field into sub fields in ch
I 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?20Views1like2CommentsUpdate records in Sync Table
I 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?2Views1like1CommentRe: Webhook or action to create parent record on child import
When 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.?4Views0likes0CommentsWebhook or action to create parent record on child import
We 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?21Views1like9CommentsRe: UPC code (12 digit text field) being converted to Scientific Notation in Excel
Funny. 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.178Views0likes0Comments