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

648 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!


2 Replies 2
7 - App Architect
7 - App Architect


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)

Screen Shot 2023-02-02 at 10.24.06 AM.png

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

Screen Shot 2023-02-02 at 10.24.17 AM.png