Hello - hoping someone can help! I feel (hope?) the solution is simple, but I am totally stumped!GOAL: I am trying to summarize the total number of unique values across 4 linked record fields. CONTEXT: I run a coaching business that hosts group coach...
Hello Airtable Community!I am trying to build something and I am STUMPED. Hoping someone can help! CONTEXT: I run a coaching business that services multiple clients. I am trying to build a tracker that tracks the number of coaching sessions that are ...
Hello! I am currently trying to extract information from an inconsistent string of text and having a tough time.Ideally, I would be able to drop the MONTH and DATE from the String of text and KEEP the all the text along with just theYEAR. The trouble...
Hello! I have a Typeform that is connected to an Airtable base.There is one question that in the Typeform that is a multiselct (the user can pick more than one option).When it translates to the Airtable multiselect field (the field is call "Select Da...
I am trying to use a script in order to identify duplicate records in a table
Description:
Duplicate record field = Participant Name
Desired outcome:
When a duplicate record (repeated Participant Name) is created in the table labeled “Ops: Program Hu...
@pressGO_design scripts and I haven't even met yet 藍 but I feel the intro is coming haha.This is super helpful - going to play around with what you shared here and will report back if I get stuck again!Really wishing there was a simple formula that c...
@pressGO_design this is amazing! I am kind of embarrassed to ask... but how did you set this up? I am still kind of new to AT!Currently, I am using count fields pointed at the linked records to sum up to that total number of sessions and then adding ...
@pressGO_design ohh interesting... I will play around with that and see if that helps!The end goal I am trying to get to show all this data in ONE table that can be layered into an interface. So I am curious if there is anyway with how I have it curr...
@pressGO_design oh no! I was afraid that might be the case (but really hope it's not!) - I just restructured the data to be set-up in this way so that I can count the total number of sessions by both the month and the client. The linked fields are gr...
@Jelani_Clay I tried that at first, but the problem is, I need to know the # of unique values across ALL 4 fields. If I use a RollUp for Unique Values for each field and then add it up, I will get duplicates.For example, with that method:Row 1 would ...
