Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Aug 04, 2022 02:29 PM
My goal is to detect overlapping usage of a resource on the same date and provide information of the respective overlapping record. For example:
I’m using an adapted version of the mark duplicate script to link records that share a matching string with each other and look/roll up information from the respective other. That worked fine until the growing dataset started causing script timeout issues (60s).
Recently @Justin_Barrett taught me how to use REGEX extract. I thought to instead create a roll-up on the resouce and REGEX extract the records string out of it. Unfortunately, it will only match the first string (and seems not easy to exclude itself).
I wondered whether there’s another way to achieve this?
Aug 13, 2022 07:08 PM
Would you please share the adapted script that you were using? It’s possible that it could be optimized to not take so long to run, but it’s impossible to know without seeing the code. When sharing the code in a reply, please style it as preformatted text using this button on the comment editor toolbar: </>