Need some scripting help - copy values and field names to another table

I have a Facilities Walkthrough table where each field represents an area. For example:

Store, 1.1 - Tables, 1.1 Issue, 1.1 Image, 1.1 Owner, 2.2 Awnings, 2.2 Issue, 2.2 Image, 2.2 Owner, etc.

12, yes, scratched top, <image of table>, dave, , , , ,

In this example, there is only a problem with the table, not the awnings ...

I have a Remediation Table that is setup like this:

Store, Area, Owner, Issue, Image

I want to use a script to take any area with an issue and push it over to the Remediation Table.

So in the Remediation Table, once data is pushed over from the Facilities Walkthrough, it would look like:

Store, Area, Owner, Issue, Image

12, Tables, Dave, scratched top, <image of table>

Thanks in advance for any help!

Hello,

I think I understand what you are asking. But can you please provide screenshots of your tables?

Second, how do you want your script to be triggered? An automation? Clicking a button? Directly from the script extension?

AirBenderMarcus wrote:

Hello,

I think I understand what you are asking. But can you please provide screenshots of your tables?

Second, how do you want your script to be triggered? An automation? Clicking a button? Directly from the script extension?

I would setup an automation to run the script whenever a new record is created.

Table 1 - FacilitiesWalkthrough (has the data)

Table 2 - Remediation (where I want to put data when it exists)

2 replies