ContributionsMost RecentMost LikesSolutionsRe: Search for unique records pipeline Thanks for the help Mark and Mike. I thought this would be a pretty niche thing. I ended creating two checkboxes, one for whether it has already been imported (gets checked during the pipeline) and another for the lowest record ID that hasn't been imported (formula field). The pipeline is first triggered manually with a button that changes a date/time field and at the end calls another pipeline that searches for the lowest record ID to be imported checkbox to be checked and changes the date/time field to trigger the main pipeline again. That way it works iteratively through the records I imported. I probably made it more complicated than it needed to be, but it works. Thanks again, ------------------------------ Rob Brown ------------------------------ Search for unique records pipeline Hello, Does anybody know a way to search records in pipelines for unique values? I have three tables - Projects, Boreholes, and Sections that are all related via Record ID. One Project has many Boreholes and many Sections, one Borehole has many Sections. We receive data in a spreadsheet of Sections metadata and I am trying to create a pipeline to check if the Project and/or Borehole exists, then add the Record ID to the Section if it does or create a new Project and/or Borehole if it doesn't. I set up the pipeline to be triggered when a record is created in Sections - Record Created -> Search Record -> If List of records is empty -> then Create Record, else Update Record. However, it appears pipelines work asynchronously. Meaning, it hasn't went through the create record step before it searches Projects and Boreholes again for the next Section record that was created - leading to multiple Projects and Boreholes records being created with the same name. My next thought is to create button to trigger a pipeline after everything is imported and then search the newly imported records, but I'm not sure how to limit my search to only unique values. This became very long, but does anybody know a way to search records in pipelines for unique values? Thanks, -Rob ------------------------------ Rob Brown ------------------------------ Re: Remove hyperlink to email addressI was wondering if that may be the issue. I was hoping I was just missing something in the settings. Maybe I'll to dig through browser settings before I resort to altering it in a formula. Thanks Mark. ------------------------------ Rob Brown ------------------------------ Remove hyperlink to email addressHello, I have a table with a field for email address. I would like to remove the hyperlink, so it doesn't open a mail client when you click on it. I have tried to set the type as both email and text, but don't see anything in the settings. Is this possible? Thank you, -Rob ------------------------------ Rob Brown ------------------------------ Distinct count in chartI need to create a barchart of the number of visitors to our facility over the years. Each record in our table is is one day, so if someone was here more than one day there are multiple records. I have created a summary report using the distinct count feature and then group by Year, but can't figure out a way to do it with a barchart. Is there a formula I can use to count the number of unique visitors? Or can I create a barchart using the summary report? Thank you, ------------------------------ Rob Brown ------------------------------