is it possible with quickbase to Trim or Remove First part of a field when being pulled into another field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a Field labeled 'Sidemark' that looks like this "PLT MV8 05401". 

i will be Pulling this Sidemark Field into another Field with other Fields but i need to Trim/ Remove the First 8 Characters so only the "05401" will show.

This is what my Current Formula looks like the Sidemark Currently Shows the Full "PLT MV8 05401"

Upper(List("\n", [Builder - Name], [Community Name], [Sidemark], [Address: Street 1], List(", ", [Address: City], List(" ", [Address: State/Region], [Address: Postal Code]))))


This is what it looks like on the viewing page

"Builder name
Community name
PLT MV8 05401
address line 1
City, State zip"


 Ideally i would like to change the "PLT MV8 05401" Line to Display "LOT 05401"

 the 'LOT' Part would be inserted before the [Sidemark] field since the sidemark does not Include the word Lot and i would like it to. 
Photo of Accounting

Accounting

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Give it a few more weeks, and your new application will be built with this feature already built in ;)
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Kirk,

Here is the fixed formula, I already changed it in the app as well.

Upper(List("<br>", [Builder - Name], [Community Name], "Lot # "&Right([Sidemark], " "), [Address: Street 1], List(", ", [Address: City], List(" ", [Address: State/Region], [Address: Postal Code]))))