Jump to content
Salesforce and other SMB Solutions are coming soon. ×

How to Import .xls with script on a button


jessd
 Share

Recommended Posts

Dear FM Forum,

I have FM 15 Advanced for Windows, but rather a newbie to FM.

I would like to automate the ability of my users (teachers) with a button  that will allow each

teacher to import an excel spreadsheet of their grouped students assigned to each class that each teacher has.

Each student already has a serial number in the .xls so no auto enter serial is necessary.

Could some of you  please discuss, or refer me to a script I can begin to work with, to perform such

An import in the button setup.

Your advice would be much appreciated.

-          Jess

Link to comment
Share on other sites

Greetings Jess. Attached is one option.

Essentially, you have the user drop the file into the container field. From there you have 2 options.

  1. Give them a button to "Import" the file.
  2. Use a script trigger to automatically run the script.

 

Make sure that you use Show All Records so that any existing records already in the file can be imported without creating duplicate records.

Let me know if you have any questions.

FileImport.fmp12

  • Thanks 1
Link to comment
Share on other sites

  • 2 weeks later...
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use