Skip to main content

Formula for Character-Count

  • November 12, 2016
  • 27 replies
  • 287 views
Show first post
This topic has been closed for replies.

27 replies

Justin_Barrett
Forum|alt.badge.img+21

So, I’m trying to come up with a way to complicate this and I believe I have found it. I have an ever changing array of characters that can be sequential but may not be (A, B, C, D, F… etc.) and I want to count the occurrence of each one in a much longer array (AAACCCBBDDIIFFIAAHDICCHAIKLA… etc.). I have my base structured such that one field (Field 1) keeps track of my changing array like above, and another field (Field 2) that keeps up with a concatenated larger array. Any one have any ideas on counting each character from Field 1 in Field 2?

Thanks!


To pull that off, the software needs some way to iterate through both arrays. Airtable isn’t built for any kind of iteration…yet. I’m confident that this will be possible someday, but today isn’t that day. Sorry.

    C
    Forum|alt.badge.img+1
    • Christopher_Wi1
    • Participating Frequently
    • August 12, 2019

    To pull that off, the software needs some way to iterate through both arrays. Airtable isn’t built for any kind of iteration…yet. I’m confident that this will be possible someday, but today isn’t that day. Sorry.


    Thanks for the reply Justin. I have been racking my brain to come up with an iteration work around, without using an API (mostly because I’m not yet knowing how to write/implement an API).

    Terms & ConditionsAccessibility statement