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
Yikes! NO!

1. Rename the field.
2. Make a new field which is a text formula field and put in the formula.

As for the formula, all it will do is to check if a field ends in (c) and if not it will add that as a suffix.  As for first name, last name, full name it really does not care, as not really "self-aware" as yet - but maybe future versions of Quick Base will have feelings, like when Dr. Noonien Soong gave data emotions. http://www.startrek.com/database_article/soong
  • RyanRyan2's avatar
    RyanRyan2
    Qrew Assistant Captain
    8 years ago
    you'll have to break that down. not proficient enough in quick base to understand.