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.