Skip 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.

Get Table Fields as List

jgrunschel
in Script Workspace and Script Triggers

Featured Replies

Hello,

I was wondering if there is a Get function that retrieves the names of all of the fields from a specified table and returns them as a value list.

For example lets say you have a table of People with the following fields:

ID

FirstName

LastName

Address1

Address2

...

Then, GetFieldNames ( People ) would return:

ID

FirstName

LastName

Address1

Address2

...

A custom function could probably do this, but I am not very skilled at writing CFs. I did a really quick search of Brian Dunning's site, but did not see an appropriate CF.

No custom function necessary.

Use the FieldName() function but instead of a layout name for the second argument, supply the table occurrence name (making certain there is no layout with the same name).

  • Author

Awesome! Worked like a charm:

FieldNames ( Get ( FileName ) ; Get ( LayoutTableName ) )

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

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.