Import Reference Fields Based on Proxy
Hello, Is there a way to import records into a table and use the proxy value for a reference field? I have a field that is generated by a formula which cannot be designated as the key field even th...
Forum Discussion
Brian,
Is this a onetime import of data? If you are not going to repeat it, then the VLookup is the quick way to go.
If this is going to be a regular occurrence there is two ways to tackle.
1) Write an script to find the Record ID and then import the data. I am guessing the PHP would do this in a couple paragraphs of code.
2) Build a separate Import Table. Use a Trigger from Juiced to search the Parent Table and find the Record ID. Then the Trigger will copy that record to the real child table and relate it to the parent. The last part of the Trigger deletes the information in the Import Table.
www.juicedtech.com
Their Triggers tool is awesome.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Is this a onetime import of data? If you are not going to repeat it, then the VLookup is the quick way to go.
If this is going to be a regular occurrence there is two ways to tackle.
1) Write an script to find the Record ID and then import the data. I am guessing the PHP would do this in a couple paragraphs of code.
2) Build a separate Import Table. Use a Trigger from Juiced to search the Parent Table and find the Record ID. Then the Trigger will copy that record to the real child table and relate it to the parent. The last part of the Trigger deletes the information in the Import Table.
www.juicedtech.com
Their Triggers tool is awesome.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Got it. It would be done every time we start a new project which would typically be a few times per month. Usually it's hundreds of locations at a time. I think for now, VLOOKUP would work for what we do. Thank you!
------Original Message------
Brian,
Is this a onetime import of data? If you are not going to repeat it, then the VLookup is the quick way to go.
If this is going to be a regular occurrence there is two ways to tackle.
1) Write an script to find the Record ID and then import the data. I am guessing the PHP would do this in a couple paragraphs of code.
2) Build a separate Import Table. Use a Trigger from Juiced to search the Parent Table and find the Record ID. Then the Trigger will copy that record to the real child table and relate it to the parent. The last part of the Trigger deletes the information in the Import Table.
www.juicedtech.com ;
Their Triggers tool is awesome.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
