Jump to content
Sign in to follow this  
aaroncp

Automatic Script Execution

Recommended Posts

Good morning everyone. I am a fairly new FileMaker developer -- okay four weeks in -- and need to automate a script's execution every time a record is viewed, created, or edited.

It's a simple script to populate a field with a URL generated from another field in the record. Is there any way to make it automatic? I've added this URL field and would like to go through the 4000+ records and have it generate the thumbnail URL automatically, and then be able to have it do so when new records are added on its own.

I can't seem to figure out how to do it without running the script manually, though.

Any help is greatly appreciated.

thanks,

Aaron

Share this post


Link to post
Share on other sites

Welcome to the Forum.

If I'm reading you correctly you want to populate another field with data from secondary field(s).

You can accomplish this by using a calculated field or an auto enter calculation and concatenating the data.

"WWW." & datafield &".com"

If that's not what you are trying to do can you be a little more specific and give us an example.

Edited by Guest

Share this post


Link to post
Share on other sites

Thanks for your reply and, yes, that's what I'm doing, but I guess what I'm saying is I don't know how to get it to auto-calculate.

I have a field called "Model" which holds a the model number of a product. I am generating via script another field called "Thumbnail URL" that creates the URL from the Model.

I have the script working and can create the proper URLs, but I don't know how to get it to do it on the fly, as the items are entered.

Share this post


Link to post
Share on other sites

You don't need a script to do this. An auto enter calculation will accomplish this.

Go to Manage>Database

go to your "Thumbnail URL" field

Click Options

Click Auto Enter Tab

Click Calculated Value

enter your concatenated formula

"www.mydomain.com/"&Modelfield

Check "Do Not Evaluate if all referenced fields are empty"

And depending on your needs check or uncheck "Do not replace existing value.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.