Default values while duplicating a record and creating a new record.
I have a requirement where i need to:
a) clear a field (Field is a URL) when a duplicate record is created.
b) Use a default value (Field is a URL) for the same field when a new record is created.
I have tried to do below:
File>Manage>Database and selected the field ..went to auto enter tab, checked the Data option leaving the field blank. This works when i create a duplicate record, but i have an issue while creating a new record.
When i create a new record the field is left blank becuase of "Auto Enter" solution whereas i require the field to set with a default value when a new record is created.
Can anyone please suggest a solution for this?
Please let me know in case you require any additional informaiton.