AnsweredAssumed Answered

How to script an import from excel to a portal?

Question asked by ziceg on Nov 12, 2012
Latest reply on Nov 15, 2012 by ziceg

As always scripting is my weakest point.... I would like to set up an easy way to import from excel some records to go into a portal. Let me explain this a bit better...

 

I have:

- Table A with various fields, and ID field

- Table B (part no, description, qty) ID field and link field to Table A ID field

- Layout 1 where all the info for Table A shows and via a Portal info of Table B is shown

 

The aim is that whenever the user is in a particular record on Table A he can import from an excel sheet various items into Table B for that particular record on Table A. This is going to be a recurring thing so I would like to put in a scripted button to make it easy on the user.

 

Thanks

Outcomes