Use a script with a button to duplicate the current record and also clear the URL field.
Set Field [YourTable::YourURLfield ; "" ]
I'm a beginner so I'm sure there will be better ways to achieve what you want...
Thanks for the response.
Our users use the functionality available in the menu "Records>Duplicate Record" to create a duplicate record. How can i assign (trigger/perform) a script to this functionality?
In 'Edit Layout' mode, draw a button using the tools or type "Duplicate" using the text tool.
Right click your new object and choose 'Button Setup...'
Choose 'Perform Script' then click the 'Specify' button
Click the '+' button to create a new script and give it a name
In the left hand colum under 'Records', double click 'Duplicate Record/Request' to add this script item to your new script
Under 'Editing', double click 'Clear' to add this item
Tick the 'Select entire contents' and 'Go to target field' checkboxes
A dialog box will pop up, select the relevant (URL) field and click ok a few times to exit out of all dialogs.
Go to browse mode and click the new button, the existing record should be duplicated except for the URL field remaining blank...
Why not enter the default URL into the Data box?
Brian Curran: I completly got what you said and I tried the steps you mentioned and it works. But the issue here is there are around 100 users and they all use "Records>Duplicate Record" functionality available in the FMP Advanced menu to create a duplicate record (Please find the image attached).
You are asking me to create a seperate button on the existing Layout. I wanted to use the existing functionality of Duplicate record and empty the URL field when i do duplicate record and Use the default value when i create a new record.
Hope you understood!..
PhilModJunk: I can enter the default value in the Data box but the issue is I get default value even while creating a duplicate record.
The functionality should be:
a) getting a default value when new record is created
b) Leaving the field blank when duplicate record is created.
To do what you want, you'll need to use FileMaker Advanced to create and install a custom menu set. With a custom menu set, any menu option can perform a script of your design instead of the standard FileMaker action assigned to that menu option.
Thanks this helps!! I have fileMaker advanced and I tried to do with editing the custom menu set and added a script to delete the field value when duplicate record functionality is done and it workss!!
Also, Currently the my FMP layout uses [standard file maker menu], to do my requirement i need to change the menu set to "custom menu set". If i use the custom menu set some of the functionality available in [standard file maker menu] set are not available.
I can compare all the functionality of standard file maker menu and add it to custom file maker menu.
But is there any way where i can see properties of standard fileMaker menu set?
If i use the custom menu set some of the functionality available in [standard file maker menu] set are not available.
And what functionality have you lost? Simply altering one menu so that Duplicate Record performs a script shouldn't affect the rest of the menu set and how it functions.