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.

how to create calculation auto-enter for related fields

Featured Replies

Hi

I would be most grateful if you could help me with creating a calculation field.

I have 3 tables related with an 'id'. The first table is the one that has all the 'real' fields and the two other tables only have the 'id' field while they are the ones whose non-existent fields are filled in and automatically entered into the first table. (does this make sense?). the first table is not visible to other users.

I would like to create a calculation field in the first table, that when someone enters data into the 2nd table, the 'item' field in the first table will be auto-entered as 'one', while when the 3rd table is filled in, the 'item' field will be auto-entered as 'two'.

Is that possible?

Many thanks!

Digit,

I'd rather explore your data model in more detail. Can you provide real details of what you're trying to achieve? What are the tables?

Create an account or sign in to comment

Important Information

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

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.