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

Script to delete contents of a specific field


saltobello
 Share

Recommended Posts

I want to make a button which will untag every found item that's tagged. I'm getting stumped on what kind of script would do this.

 

Also, in a related issue, I have a problem where many files have been imported into my database with some wrong fields assigned. Subsequently, I have about 1000 fields with the wrong info in it. I can't do a batch delete and re-import (a co-worker's already begun modifying the fields, so a re-import would mean all of that work would need to be re-done), so I'd like to be able to run a script that only deletes the contents of a specific field, for every found item. I guess this might be the same script as above, with the field name swapped out, right?

 

Thanks!

Link to comment
Share on other sites

I want to make a button which will untag every found item that's tagged. I'm getting stumped on what kind of script would do this.

 

Enter Find Mode []

Set Field [YourTable::TagField; "Tagged"]

Set Error Capture [On]

Perform Find []

If [Get(FoundCount)>0]

Replace Field Contents [YourTable::TagField; ""]

End If

 

so I'd like to be able to run a script that only deletes the contents of a specific field, for every found item. I guess this might be the same script as above, with the field name swapped out, right?

 

Right.

Link to comment
Share on other sites

Whiteout is also the newbie secretaries answer...

 

If the field is editable you can also click in the field and use the menu item for replacing contents which works the same as the button script above.

 

This has the advantage of being hidden from most users and unlikely to be used accidentally.

 

It is also good to not have a Delete Selected Records button on a layout for those who don't understand that they can delete the entire database...

 

Oh Really!

Link to comment
Share on other sites

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