Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Jeffrey_Brandt
6 - Interface Innovator
6 - Interface Innovator
since ‎Jun 09, 2020
‎Nov 29, 2022

User Statistics

  • 13 Posts
  • 0 Solutions
  • 4 Kudos given
  • 12 Kudos received

User Activity

Find overlap in Airtable

Aug 30, 2021
Hi, I have a base I use to request rooms. Is there a formula I can write to let me know if there is overlap in a request? For example: 1/10/2022: I have a request for 4 large conference rooms for Group 1 from 10-12 1/10/2022: I have a request for 3 m...

Perform a search off of a rollup?

Jul 13, 2021
Hi, I have a rollup field (called “Lessons Included”) that won’t work in the following formula: IF(AND(FIND(“Math”, {Lessons Included}), {Submit Date}=BLANK()), “Math Pending”, IF({Submit Date} = BLANK(), “Math Not Included”, DATETIME_DIFF( {Material...

Enter value if my rollup is blank

Jul 13, 2021
Hi, I have a conditional rollup where I am doing an Arrayunique of events that occurred in a specific Academic Year. If the array is empty (meaning, the event was not scheduled in said year), then I want the rollup field to say “Not Scheduled”. Is th...

Help with script to combine URL and text

Jun 30, 2021
Hi, Using the following script from this post, I created a field that combines a URL and text: let tb = base.getTable(“URL Test”); let query = await tb.selectRecordsAsync(); for (let record of query.records) { let url = record.getCellValue(“URL”); le...

Search/Filter Comments

Jun 16, 2021
It would be great if I could search/filter/sort/group based on comments. Is that an option that I’m just not aware of how to use?
View more
Kudos given to
Copyright © 2025 Khoros, LLC
Top