View only the last 4 lines in a data field?
Hi, I'm new to QuickBase and I'm having trouble with a formula for a text field. We have data line 1-7, but I only want to pull the last 4 lines in the data (data lines 4-7). I've tried using the part...
Forum Discussion
Can you post an example of what your data looks like?
Hi, Thank you for the code. We tried using this code and we get a formula error.
A formula may not contain a reference to itself directly or indirectly through another formula.
Here's the updated code I used.
var text StepOne = SearchAndReplace([Long Text Formula],"MST","|");
var text Message = Right($StepOne,"|");
var text RestOfMessage = NotRight($StepOne,"|");
var text DateStamp = Right($RestOfMessage,"\n");
Trim($DateStamp & " MST " & $Message)
Thanks!
A formula may not contain a reference to itself directly or indirectly through another formula.
Here's the updated code I used.
var text StepOne = SearchAndReplace([Long Text Formula],"MST","|");
var text Message = Right($StepOne,"|");
var text RestOfMessage = NotRight($StepOne,"|");
var text DateStamp = Right($RestOfMessage,"\n");
Trim($DateStamp & " MST " & $Message)
Thanks!
