James_Otey - profile

James_Otey · Apr 08, 2020

Scenario: Airtable is used to track visits to a facility. The facility sells 10-pass “punch cards” that expire after 10 uses.If the person doesn’t use the 10 punches before a specified end date, the punch card expires. I have a base set up with 3 tab...

James_Otey · Oct 22, 2019

I have 2 tables: Table 1 is a list of every country in the world Table 2 is every possible 3 letter combination of the English alphabet (all 3 character strings) My goal is to see how many countries contain each 3-letter string. I linked each of the ...

James_Otey · Oct 23, 2019

Thanks! I actually came back here to post that I had figured out the solution, but you beat me to it. My code was identical to yours. Much appreciated :grinning:

User Statistics

User Activity

Find the Count of Occurrences of Dates in an Array, Limited to a Date Range

Using FIND() on an ARRAYJOIN() returning inexpected results

Re: Using FIND() on an ARRAYJOIN() returning inexpected results