Raymond_MarlonT
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Log Number
Hi @Mark Shnier It worked. Thanks for your help. Just a follow-up question, if I use the same formula you provided to a different field type for example a Date Type only (ex. Opportunity Date) var date MyDate = ToDate([Opportunity Date]); var text YY = Right(ToText(Year($MYDate)), 2); var text MM = PadLeft(ToText(Month($MyDate)),2, "0"); List("", $YY, $MM, ToText([Record ID#])) How come I'm getting a another formula error? May you please advise what should be the new formula? ------------------------------ Raymond Marlon Tiangco ------------------------------Re: Log Number
Hi @Mark Shnier Here is the code for the Text Formula field. var text MyDate = ToDate([Quote Date & Time Processed]); var text YY = Right(ToText(Year([Date Field])), 2); var text MM = PadLeft(ToText(Month($MyDate)),2, "0"); List("", $YY, $MM, ToText([Record ID#])) ------------------------------ Raymond Marlon Tiangco ------------------------------Re: Log Number
Hi @Mark Shnier I tried the changes you mentioned, but I'm still getting Syntax Error message var text MyDate = ToDate([Quote Date & Time Processed]); var text YY = Right(ToText(Year([Quote Date & Time Processed])), 2) var text MM = PadLeft(ToText(Month($My Date)),2, "0"); List("", $YY, $MM, ToText([Record ID#])) Kindly advise. ------------------------------ Raymond Marlon Tiangco ------------------------------Re: Log Number
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 ------------------------------Re: Log Number
Hi @Paul Peterson Hi I'm getting "Formula error -- Bad or missing arguments in function call" message when I tried to use this formula ToText(Right(Year([Date Field]), 2)) in the "Year Date" Formula text field. Is there another way? Please advise. ------------------------------ Raymond Marlon Tiangco ------------------------------Re: Log Number
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 ------------------------------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 may Rich Text (Formula) field to to show 2112001 Where 21 = year, 12 = month, 001 is login number Please advise. Thank you in advance. ------------------------------ Raymond Marlon Tiangco ------------------------------
