In an effort to save weeks worth of research, I’m hoping to find someone who may know the most efficient way to build out an automation process. I have no experience with computer language or programming and am officially waving my white flag.
I essentially need to build a custom numerology app.
I need to be able to press a button in my Airtable and run a program to break down each name (first, middle, last - each in separate columns) into individual characters and assign each letter to a number.
There are more steps to the process as a whole, but this is my primary need for assistance.
I’m fairly certain this can be done with a formula by splitting the text string (name) into individual characters; however, I don’t know how to make this a dynamic process (for the len and/or mid functions) nor do I know how to run a split function without a delimiter.
If anyone has any suggestions, all feedback is appreciated!
As briefly mentioned, there are more steps to this process and I would be more than willing to hire someone to help me build out a few of my needs - I’m a new business owner and the need for automation is rising exponentially. Please PM me if this is something you would be interested in discussing - otherwise, any advice will help tremendously.
I was able to get a great start on the script thanks to Bill (code can be found in the comments) – I’m still searching for someone who can help me finish the rest, so I’m going to put the remaining project details below.
- Bill’s quick script is nearly perfect - I just need for the conditional characters (oBaseClass) to search the entire string for the letter combinations instead of just the first 2 letters. For example: TAylor has one condition, whereas TAbaTHa and ASHworTH would have 2 conditional values assigned.
The remaining steps may seem complicated/extensive at first glance, but it’s actually very simple (just specific details).
- Instead of adding up the total for each name, the individual values will be assigned to a specific column (6 columns) in sequential order. After the first 6 letters fill all the columns, you just start at column 1 again and loop through until every letter in the name has been assigned.
Let’s let our 6 columns be labeled as such:
column 1: PK
column 2: SK
column 3: PT
column 4: ST
column 5: PG
column 6: SG
In this photo you can see the numerology value of each character and the column it would be assigned to:
- This is where the values would now be added together. There is a special rule for this step, as well. The final value in each column will consist of a pair of numbers (X-X) instead of a single sum total.
You will add all of the numbers together for an initial total. If that total is more than than 22, you will reduce the number by adding the individual components (ex: total=46 ; 46>26, so reduce: 4+6 = 10 ; 10<22, so ) < this will be the first number of the pair. The second number is the furthest reduction of the total to a single digit number (ex. 10 = 1+0 =1 ; FINAL = 10-1
here is a complete example using my name as we did in the earlier screenshots:
I know that’s a lot of info - but I’m more than happy to answer any questions about the process & will gladly compensate for time spent on development of this script if anyone has the capacity to assist! This would be a tremendous help to me, and I appreciate you taking the time to read my request (if you made it this far ).