Sep 24, 2024 12:36 PM
I have a gallery view of event participants embedded on our web site. On the card view, one particular field is followed by a big extra space - see right after the 'City, State' field in the screenshot here:
This extra space does not appear when you click on the card to see the record detail:
The only difference in the data is that the 'City, State' field is a formula, combining two fields with a comma. But, I don't know why that would display an extra line in the gallery card. Any ideas?
Sep 24, 2024 07:27 PM
Hm that's a weird one. I tried replicating it but wasn't successful:
Any chance you could provide access to a duplicate of the base with no data in it for me to poke at? Pretty curious about it!
Oct 10, 2024 08:29 AM - edited Oct 10, 2024 08:35 AM
Sorry I got busy and neglected to reply - now I have a bit more time I tried investigating and I think I have narrowed down on the cause, and found a workaround.
I also tried creating a fake base with fake data to share with @TheTimeSavingCo , and could not replicate the issue.
The data in the original post is synced from another base...We have one large base with volunteer data (call this base CRM) and this syncs one-way to another base which we use to manage the volunteer involvement in various activities and events (call this base PROGRAMS). Check out the same record in both places:
The two formula fields, 'InformalSalutation' and 'CityState' are getting an extra line added in through the sync. I notice that in the destination (PROGRAMS) base these fields have been converted to Long text, which seems to be causing the extra line:
I created a test formula field in the destination (PROGRAMS) base, exactly the same as the formula that was being synced, and it DID NOT create this extra line:
I tried pointing this formula at the synced field and it worked, so this would be an easier workaround than trying to rewrite the whole formula in the destination base.
Oct 10, 2024 08:34 AM - edited Oct 11, 2024 07:46 AM
Summary: When a formula field gets synced to another base, it is converted to a Long text field and adds an extra line in Gallery view cards.
Workaround: Create a formula field in the destination base, not in the sync source, to avoid this extra line. You can simply point it at the source formula field which synced and it should format correctly.