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
Are you really asking because your current data is in two fields, and it is just the last name that needs the suffix?  Are you looking to have Quick Base have a formula to show the full name, ie first and last name and suffix if necessary?
  • RyanRyan2's avatar
    RyanRyan2
    Qrew Assistant Captain
    8 years ago
    no. we use last name as the customer id, nothing else. quick books cannot have the same name twice. and we use same people as a customer and vendor. so we need the last names in quick base to have a suffix of (c) for a customer, so when we go in quick books and refund the money we can add them as a vendor.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    OK.
    Let m know the names of your fields and I will help you with the formula.
  • RyanRyan2's avatar
    RyanRyan2
    Qrew Assistant Captain
    8 years ago
    i only use one field. Customer ID