ContributionsMost RecentMost LikesSolutionsHow to get CSV Upload and automations/actions to skip over dupesI have set up actions/automations to add records to table 2 when a record is added to table 1. I have a key field where table 2 prevents dupes from being created. I do not mind if dupes are in table 1. When manually/individually adding records and dupes to table 1 it will add the first record to table 2, but not the dupes that follow.... just how I want it to. However when I do a csv upload where there are dupes, the action/automation breaks and does not add the records to table 2. How can I work around this? Essentially I would like the automation/action to skip the dupe and continue running skipping to the next line on the csv, instead of breaking.Parent Record with Summary fields of multiple ChildrenI have 2 tables Parent and Child with a 1 to many relationship where Parent can have many children. I am trying to create summary fields in the Parent record such as First Child Second Child Third Child Fourth Child etc.. struggling to make this happen.. Any help would be greatly appreciated.Hide Record Name/# when printing individual recordI have a table called Leads. When I print an individual lead record with record id 7 at the top of the page it says "Lead # 7" above the form and information. Is there a way to hide the "Lead # 7" and just print the form with the data?How to find the difference between column totals from two different tables/reportsI have 3 tables. Table 1 is Customers Table 2 is Deposits Table 3 is Deductions Relationship 1 is Customers have Many Deposits Relationship 2 is Customers have Many Deductions At the bottom of the related deposit report and deduction report displayed on the Customer record I can see each reports total value. I would like to create a Numeric Formula field on Customers table that will equal the difference between the total Deposits and the total Deductions. I am struggling to find the values to create this formula.Re: How to Capture Parts of a Long StringSorry I wasnt clear... each section would be its own formula text field. First Name would be its own formula text field and i want it to return "John" Last Name would be its own formula text field and it would return "Smith" I also want the format of the string not to matter.. meaning I could pass in the string "Job_Programmer_LastName_Smith_FirstName_John" and it would return the same resultsHow to Capture Parts of a Long StringI have a string "FirstName_John_LastName_Smith_Job_Programmer" I would like to capture with formula text fields First Name: "John" Last Name: "Smith" Job: "Programmer" I've tried playing around with Part Formula with limited success Is this possible?Re: Is it possible to export records to a google sheet in real time?I agree and understand what you're saying, however I have specific reasons for this. Thanks for the documentation.Is it possible to export records to a google sheet in real time?I am trying to export data/records to update a google sheet automatically whenever a new record is created. Is it possible to do this natively in Quickbase?CSV Upload... bulk record creation with related parents/children records...I currently have a table titled Customers as a parent table and a child table titled Orders. (a customer can have many orders) I know I can upload a csv file that will create Customers records in bulk. I was wondering if/how I could upload a csv file of Orders that associate with the appropriate existing Customers.Re: Custom Error Message According Unique FieldsThanks. Why do you not think its a good idea?