Help

Re: Gallery view layout issue on formula field

366 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Kruse
6 - Interface Innovator
6 - Interface Innovator

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:

Michael_Kruse_0-1727206348043.png

This extra space does not appear when you click on the card to see the record detail:

Michael_Kruse_1-1727206406967.png

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?

3 Replies 3

Hm that's a weird one.  I tried replicating it but wasn't successful:

Screenshot 2024-09-25 at 10.26.19 AM.png

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!

Michael_Kruse
6 - Interface Innovator
6 - Interface Innovator

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:

Michael_Kruse_1-1728573732243.pngMichael_Kruse_2-1728573783192.png

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:

Michael_Kruse_3-1728573997232.png

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:

Michael_Kruse_4-1728574162126.png

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.

Michael_Kruse_5-1728574491355.png

 

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.