Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Is it possible to format parts of calc. fields?

Featured Replies

Hi,

I'm creating a db of books. I have fields for Author, Title, and Publisher. I want to join these together with a single calculated field to make a citation, such as:

Author&". "&Title&". "&Publisher&"."

with the result:

Smith, Joe. Book of Knowledge. Everything Press.

Is there any way that I can italicize the Title and leave the rest in regular type?

I thought of just placing the three fields next to each other and italicizing the Title field. But since I don't know how long the Author field will be, it won't look like a single entry. I could use sliding fields for printing, but there is no way to get the effect of sliding in Browse mode, is there?

Any ideas?

Thanks,

Dan

Hi Dan,

Try using Merge fields on your layout. You can then apply individual formatting to the merge fields.

HTH

Lee

ooo.gif

Lee,

What if your calculation is of the sort: -- if (function (fieldA), result1, result2) and you'd like result1 to be bold but result 2 to be plain text? You can't use merge functions here (or can you???) confused.gif

Abbe

Try a combination of your original idea and Lee's

I thought of just placing the three fields next to each other and italicizing the Title field.

Try using Merge fields on your layout. You can then apply individual formatting to the merge fields.

<<Author>> , <<Title>>. <<Publisher>>

-Raz

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.