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.

Tab command in calculation?

Featured Replies

I'm trying to move data from several portal rows of 4 fields into a printable invoice layout.

Using the portal in the invoice layout doesn't work, because Print Sliding is too limited.

So I thought why not collect the data in one large field using tabs. But Is it possible to place a tab command in a calculation?

Collecting data from 4 fields and placing a space or a line-end twixt each is easy, but I'd really like to have the collected data on one line at specified distances apart. (I can set up the tab positions.)

I have tried typing opt+tab between quote marks in the calc field, but all I get is highlightable blocks of nothing.

If I can't do this, I'll just have to transfer the data into multiple rows of 4 fields (with print sliding). It'll just take a more complex calc to set this up.

Any thoughts gratefully received.

You can use the Char function, for a tab it would be Char ( 9 ). But I would recommend you take a look at some examples of invoice solutions here. It sounds to me like your trying to print the invoice from the header table, and it is normally printed from the line items table.

I'm trying to move data from several portal rows of 4 fields into a printable invoice layout.

Using the portal in the invoice layout doesn't work, because Print Sliding is too limited.

As Rod suggests, it is better to print from your LineItems table. You have a LineItems table, right? Printing from LineItems as Report layout will allow for unlimited numbers of items and allows grouping and sub-summaries (so you can even print several invoices at a time). It is sure easier than combining 4 fields of several items into concatenated calculation in the Invoices table. :^)

  • Author

OK - yet another learning curve here then - many thanks to both for the swift advice.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.