Donnie

Hi, Moving to Caspio from Quickbase and I am trying to write a formula that would use my record id which i have a s an auto number field and would like to add the 3 letters SPA in front of it "SPA"+[@field:record_id] - this says its in valid ans I would also need 0000 zeros so the first number would be SPA00001 This is the formula I used in quickbase: If([Record ID#]>=10000,"SPA" & ToText([Record ID#]),"SPA" & Right("0000" & ToText([Record ID#]),5)) Any help would be appreciated