Forum Discussion

Raymond_MarlonT's avatar
Raymond_MarlonT
Qrew Trainee
3 years ago

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...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion

Try 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
------------------------------
Raymond_MarlonT's avatar
Raymond_MarlonT
Qrew Trainee
3 years ago

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__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    raymond

    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
    ------------------------------
    • Raymond_MarlonT's avatar
      Raymond_MarlonT
      Qrew Trainee
      3 years ago

      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 024

      Will you be able to help create the correct formulas?

      Thanks for your help.

      ​

      ------------------------------
      Raymond Marlon Tiangco
      ------------------------------