Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Sergio,
Try pasting this into a simple formula text field. It converts the string to all numbers and then inserts the delimiters back into the string.
Change [Raw input] to your field name.
var text MyString = [Raw input];
var text PartOne = Part($MyString,1, "./-");
var text PartTwo = Part($MyString,2, "./-");
var text PartThree = Part($MyString,3, "./-");
var text PartFour = Part($MyString,4, "./-");
var text PartFive = Part($MyString,5, "./-");
var text AllNumbers = List("",$PartOne,$PartTwo,$PartThree,$PartFour,$PartFive);
Left($AllNumbers,3)
& "."
& Mid($AllNumbers,4,3)
& "."
& Mid($AllNumbers,7,3)
& "/"
& Mid($AllNumbers,10,4)
& "-"
& Mid($AllNumbers,14,2)
Try pasting this into a simple formula text field. It converts the string to all numbers and then inserts the delimiters back into the string.
Change [Raw input] to your field name.
var text MyString = [Raw input];
var text PartOne = Part($MyString,1, "./-");
var text PartTwo = Part($MyString,2, "./-");
var text PartThree = Part($MyString,3, "./-");
var text PartFour = Part($MyString,4, "./-");
var text PartFive = Part($MyString,5, "./-");
var text AllNumbers = List("",$PartOne,$PartTwo,$PartThree,$PartFour,$PartFive);
Left($AllNumbers,3)
& "."
& Mid($AllNumbers,4,3)
& "."
& Mid($AllNumbers,7,3)
& "/"
& Mid($AllNumbers,10,4)
& "-"
& Mid($AllNumbers,14,2)
- _anomDiebolt_8 years agoQrew Elite.. the age old tension between native and script, man and machine, love and heartbreak rears its head ...
- QuickBaseCoachD8 years agoQrew CaptainI�m at the airport now with time before my flight so I felt compelled to give Sergio an easier way as I can see he is trying so hard. Off now for a ski week.
- SergioSergio8 years agoQrew CadetEnjoy the snow my friend!
I have been losing all my hairs trying to get this done. But I know once i learned the first one, I will be able to implement the other ones.
I will use yours for now, but I am challenged to get this accomplished now.
Lets see if i understood:
1- I followed all the instructions and I created the user iol and /iol
2- I created the page module.js and added the long script where shows what page I am working on.
3- I created a normal text field named [taxid].
4- I need to create a field name [iol] & "module.js" & [/iol] ?
5- Is number 4 correct? or i just need to paste that "[iol] & "module.js" & [/iol]" into a another field text formula type?
Anyways, I wont give up on this one yet, but for now I will use Marks proposal so I can at least have something working today.
Thanks for both of you! - _anomDiebolt_8 years agoQrew EliteWe got you covered.
- QuickBaseCoachD8 years agoQrew CaptainIn case anybody is wondering, that is the infamous Dan Diebolt on the left and myself Mark Shnier a.k.a. Your Quick Base Coach on the right. This shot was taken at EMPOWER 2017.
Come to EMPOWER 2018 in Austin in June. Maybe you will see us in person. Well, I know I will be there hopefully Dan will make it too. - _anomDiebolt_8 years agoQrew Elite>hopefully Dan will make it too.
I might have a conflict as I am speaking at the other QuickBase conference in Austin that same week.
"Morphisms Gone Wild - Integrating ELM + Haskell with QuickBase"
http://elm-lang.org/
https://www.haskell.org/ - QuickBaseCoachD8 years agoQrew CaptainELMPOWER 2018. Very cute.
This explanation of ELM vs Haskell is quite confusing. They are using words but they don't seem to bear much resemblance to English.
https://www.reddit.com/r/elm/comments/3s6lhb/learning_elm_vs_haskell_as_an_intro_to_functional/ . - _anomDiebolt_8 years agoQrew EliteELM is a new framework for building web applications which happens to be written in Haskell (the Mac Daddy of Pure Functional Programming Languages) and transpiles to JavaScript. ELM beats the pants off of Angular and React - two frameworks your Earth based QuickBase developers are currently dabbling with.
You may not realize it but QuickBase has deep roots with functional programming. In the vast majority of programming languages If and Case keywords are controls structures (not functions) that executes one of several different statements based on some critera. QuickBase's If and Case keywords are actually functions (not control structures) that return one of several different values. In fact, QuickBase's formula language is almost a pure functional programming language - the exceptions being the two functions Now() and Today() which have the unfortunate side effect of returning a different value every time you call them. This non-pure function oddity was corrected with the invention of the QuickBase Monad and the upgrade of the formula language to script but these innovations have not yet happen in your quadrant.
I hope that this explains the tight connection between ELM, Haskell, Functional Programming and the QuickBase technology. Anyway come to my talk entitled "Morphisms Gone Wild - Integrating ELM + Haskell with QuickBase" and I will explain it in simple terms a builder can understand. - SergioSergio8 years agoQrew CadetHi Mark,
This works fine! But different than Dan's code, it does not show it the actual field being filled out. I have to create a second field to display the content of the taxid field.
Am I doing something wrong? - QuickBaseCoachD8 years agoQrew CaptainRight, my method does require two fields. If Dan�s method does it in one field, I guess that could be an advantage.