AnsweredAssumed Answered

Faster Data Entry

Question asked by JasonPenner on Aug 14, 2012
Latest reply on Aug 16, 2012 by philmodjunk

Title

Faster Data Entry

Post

I'm enlisting the help of the forum once again.

I run a modified version of the invoice starter solution for my gym. Invoices = Workouts, Products = Exercises. I use FMPro but my staff uses FM Go for data entry, the problem right now is they spend most of their time inputing data and I'd like to shave some of that off. We have different rep protocols we use, and I'd like to use a script trigger to decypher and do an action based on that.

Scenario 1

Input= "60" Output = "60"

Scenario 2

Input = "60:15" Output = Two line item entries, the first where the output is "60" and the second is "15"

Scenario 3

Input = "60/15/10/15/10" Output = Five line item entries, where the first is 60, second 15, third 10 etc

I have a feeling I'd be using the PatternCount() to determine what to do, but from there I'm lost. Please help, also I'm sure the Let () function will be used, but that concept is way over my head. Sorry for being difficult but thank you in advance for being an awesome forum.

Jason

Outcomes