
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 27, 2022 07:34 AM
Hello All!
I’m using a formula to concatenate different dates an area was worked on as the record ID. In one tab I have all the offices and all of the associated data with them, and in the other I have a submissions page that’s linked to the office page. My problem is some of them concatenate as “AreaName” - Date and others are AreaName - Date. I have attached some screenshots for a visual.
Thank you for your help!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 27, 2022 07:45 AM
That means that you have hidden characters somewhere within the area name for those records. So you’ll need to manually cleanup those area names.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 27, 2022 07:45 AM
That means that you have hidden characters somewhere within the area name for those records. So you’ll need to manually cleanup those area names.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 27, 2022 08:57 AM
Thank you! I had to end up resetting all the names.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 27, 2022 05:33 PM
For future reference, you could have also used TRIM({Area})
to remove extra spaces at the start and end of the text.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 27, 2022 07:22 PM
I believe TRIM() will only work for spaces. Last time a client of mine had this problem with quotation marks, there were lots of invisible characters of some sort (that weren’t considered spaces) that were causing this problem.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 30, 2022 01:51 AM
I get the same issue using the following
IF({_Uniclass System}=BLANK(),{Uniclass Products},{_Uniclass System}) the fields its looking at don’t have “” in them
