Log Number
Hi,
May someone help me create a formula for a Rich Text (Formula) field to be able to create a log number based on a Date / Time field.
Example:
Date / Time = 12-17-2021 1:33 PM
I want m...
Forum Discussion
Yes Login Number is just a filed on the record.
------------------------------
Raymond Marlon Tiangco
------------------------------
------------------------------
Raymond Marlon Tiangco
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendTry this
var text MyDate = ToDate([My Date / Time field]);
var text YY = Right(ToText(Year($My Date));
var text MM = PadLeft(ToText(Month($My Date)),2, "0");
List("", $YY, $MM, ToText([Login Number]))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Hi @Mark Shnier,
Is this the formula I should write in the Rich Text Field?
is "My Date / Time Field" a certain field name?
How about "My Date"?
Because my field name is "Quote Date & Time Processed"
May i know how am I supposed to type the formula? since I'm getting an error message "Formula Syntax Error"
Please advise.
------------------------------
Raymond Marlon Tiangco
------------------------------- MarkShnier__Youraymond
This would be a formula text field.
var text MyDate = ToDate([Quote Date & Time Processed]);
var text YY = Right(ToText(Year($My Date));
var text MM = PadLeft(ToText(Month($My Date)),2, "0");
List("", $YY, $MM, ToText([Login Number]))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------Hi @Mark Shnier
I try to use this formula but i'm still getting Syntax Error.var text MyDate = ToDate([Quote Date & Time Processed]);
var text YY = Right(ToText(Year($My Date));
var text MM = PadLeft(ToText(Month($My Date)),2, "0");
List("", $YY, $MM, ToText([Login Number]))Just to explain further.
I have a field named Quote Date & Time Processed, which is a Date / Time field type (example: 03-23-2022 03:30 PM)
And I have another field name Quote No., which will be my formula text field that would need the formula that would show 2203003 based on the data of the Quote Date & Time Processed, where 22 = based on 2022 year, 03 = month of March, 003 = based on the Record ID# in QuickBase so if it is Record ID# 1 it becomes 001 if it is Record ID# 24 it should be 024Will you be able to help create the correct formulas?
Thanks for your help.
------------------------------
Raymond Marlon Tiangco
------------------------------
