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.

GTRR and New Record Creation honoring Lookup function

Rich K.
in Script Workspace and Script Triggers

Featured Replies

Hello all --

I have a list of records (from TO1) in a found set (lets call FS1) and it has a date range specified. I want to loop thru FS1 and create a record for each day for each record in FS1 to a related TableOccurrence (lets call TO2). I have Lookup() functions dragging a majority of the fields from TO1 to TO2.

If I did this on screen I have a hidden layout that I transfer FS1 to ... and this hidden layout has a portal to TO2 that will allow me to add a record and all the Lookups will fire populating 95% of the new TO2 record.

I created the script based on the the above paragraph (and it doesn't seem to want to play nice).

However, I don't even know if this best way to do this ... prolly not.

Can anybody point me in the right direction?

Regards,

Rich

Edited by Guest

Can you explain what are you actually trying to achieve here? At first glance it seems like a needless replication of data.

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.