Plugin Mode

Table copy during lookup

Summary

When lookup values are retrieved, also copy table data from the source app into this app.

Smartphone support

This plugin does not support smartphones. Use it on a computer.

How to use

Choose the lookup field, the source table in the referenced app, and the destination table in this app. When the lookup succeeds, the table from the referenced record is copied. Use matching field codes for the columns to copy.

When it runs

Depending on the settings, this customization runs at the following times. Any configured conditions are also evaluated.

  • When a lookup retrieves its data successfully

Parameters

Enter or select a value for each setting unless it is marked optional.

Lookup Field

Please select a lookup field. Please note that for this plugin to work, the apps referenced by the lookup fields must also be registered in gusuku Customine.

The following field types can be selected.

  • Lookup (text)
  • Lookup (number)

Fields inside tables cannot be selected.

Source table

Please select the source table from the app you want to look up.

The following field types can be selected.

  • Table

Select from the app referenced by “Lookup Field”.

Destination table

Please select the destination table from this app.

The following field types can be selected.

  • Table

Restrictions

Register the referenced app in Customine as well. Empty source rows are skipped, and existing destination rows are cleared.

The following actions and conditions are useful when building similar behavior in customization mode.

Actions

Conditions