AnsweredAssumed Answered

sending comma separated data to multiple fileds via a push of a button

Question asked by tim_c on Jan 24, 2010
Latest reply on Feb 2, 2010 by TSGal

Title

sending comma separated data to multiple fileds via a push of a button

Post

I am currently using excel to accept comma separated data from a line of text from a web site.  Basically I go to the web site, high light the line of text, copy, go to excel, paste the data, which then

gets pasted to different cells in the same row.

 

I wanted to make a FM user interface that has the embedded web page on a tab, high light the line, copy it,  and then paste it to a field, which then would send it to the last row of the database table, ie creating a new record.

 

Actually I would like to be able paste the data, hit a VERIFY button which would see if the data is already in the table and if it is in the table it would send a popup to the user indicating the data is already present.  Otherwise it would notify the user that the data has been successfully added to the data base table.

 

Does anyone have some insight on this?

 

Thanks

Tim C. 

Outcomes