Forum Discussion

RyanRyan2's avatar
RyanRyan2
Qrew Assistant Captain
8 years ago

How to setup a field to add a suffix after submission?

The question may not have been much clear, so hopefully, this explains what I'm talking about. I ran into problems with integration with Quick Books, so my solution has to be to add a suffix "(c)" whe...
Forms
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
There are several solutions. The most simple solution is to rename your existing name field to be called Name Input.  Then maKe a new Formula text field called Name with the formula

IF(Ends(Trim([Name Input]),"(c)"), Trim([Name Input]), Trim([Name Input]) & " (c)")