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.

Find and change automatically a field

ablarer
in Finding & Searching

Featured Replies

  • Newbies

I am a newbie and have some problems.

I want to check, after I added a new record, if in all already existing records two fields a) "Product" *and* : "Seller" contain the same values as in the newly generated record in "Product *and* "Seller". If that is so I want that the field "version" in the new record goes up one number compared to the higest existing number of "version" in a already existing record with the same values in "Product" *and* : "Seller". Product, Seller and Version are number fields. E.g. Existing records:

Record 1: Product = 1, Seller = 3, Version 1;

Record 2: Product = 1, Seller = 4, Version 1;

Record 3: Product = 1, Seller = 3, Version 2.

New record.

Record 4: Product = 1, Seller = 4, Version becomes automaticaly 2 because Product and seller is the same as in record 2.

I hope it's clear want I want. Please could anyone help me?

You must create new calc field Product_Seller=Product&"_"&Seller

Then to build self relation on this field, let it be A

Then in auto enter option for Version field you must specify calculation :

"Version "&Count(A::Version)

Create an account or sign in to comment

https://fmforums.com/topic/29566-find-and-change-automatically-a-field/
Go to topic listing

Important Information

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

I accept

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.