I have an email field having some values. I want to make this field blank. The problem is I have to make this field blank for 1000 records. When I try to update the email with blank in data loader it does not update.  Please help
123596
I'm uploading records with the amazing dataloader.io and have a hard time to upload some records with NO value for optional fields. What do I have to put in those fields?   #N/A 'null' NULL '' "" 0   Is there a definite guide or reference document that answers this?
105187
I want to delete the records from Data Extension based on Date Field in my DE i.e. I want to delete record which were created date before 30 days.But I didn't find date manipulation function in SSJS like dateadd() in ampscript
78453
I have been watching how to implement the batch for sending more than 10 email but I get errors. When I send emails I have a limit 5 and also are sent several times to the same user email  global class SendBatchClass implements Database.Batchable&lt;sObject&gt;, Database.AllowsCallouts{     String query = '';      global Batchname(){     }     global SendBatchClass(String newBodyBatch,...){        this.body = newBodyBatch;        try{...}        catch(){...}     }     global Database.QueryLocator start(Database.BatchableContext BC) {          return Database.getQueryLocator(query);     }     global void execute(Database.BatchableContext BC, List&lt;Contact&gt; scope) {         SES sesEmail = new SES(as3.key,as3.secret);         for(sObject s: scope){             sesEmail.sendEmail(subRecipients,sender,subject,newBody);         }     }     global void finish(Database.BatchableContext BC) {      } }
108596
I have a custom object that I want to set a unique key based on on lookup values. When I tried to create a workflow update I was blowing past the size limit so I developed it into a trigger and it seems to be working as intended.   I thought since I am already developing a field update trigger, I might as well add on a default name method so everything is contained into one file as opposed to having workflow and triggers updating the record.   When I introduced this method it returns "null null".   public static void setRecordName(List&lt;Responsible_Party__c&gt; newList) {     for(Responsible_Party__c r : newList)     {         r.Name = r.Practice__r.Name + ' ' + r.User__r.Name;     } }   Where practice is a lookup to another custom object and user is a lookup to the user object.   If I change the values to just use the field:  public static void setRecordName(List&lt;Responsible_Party__c&gt; newList) {     for(Responsible_Party__c r : newList)     {         r.Name = r.Practice__c + ' ' + r.User__c;     } }   I get "a1Gg00000049v9xEAA 005A0000006ykwnIAA". How can I get the names to display and not null?
69888
I have a custom object, with a Text Name (ID) field. When I upsert two records with identical Name/ID, but otherwise different values, in two separate upsert statement, one record results, as expected.  When I create a list, add these records to the list, and then upsert the list, I get a DUPLICATE_VALUE error. What gives? By definition, upsert should not do this, should it? Even worse: it doesn't matter whether a record with the identical Name already exists or not, the upsert will fail in both scenarios.  By the way: by default upsert a does not use the Name/ID field as identifying/unique field, as you might expect. You need to do upsert a Name  Complete code:  List&lt;Flight__c&gt; flights = new List&lt;Flight__c&gt;(); Flight__c f1 = new Flight__c(); f1.Name = 'ABC123'; f1.Flight_Number__c = 'ABC'; flights.add(f1);  Flight__c f2 = new Flight__c(); f2.Name = 'ABC123'; f2.Flight_Number__c = '123'; flights.add(f2);  upsert flights Name;      Error message: Line: 12, Column: 1 System.DmlException: Upsert failed.   First exception on row 0; first error: DUPLICATE_VALUE, Duplicate   external id specified: ABC123: [Name]   Name being the standard identifying field of a custom object. You cannot edit the properties of this field, e.g. making it unique or not unique.
107111
Upon page load I want to move the cursor to a particular field.  No problem.  But I also need to select and highlight the default value that is placed in that text field.
34616
So I have a date field that needs to be a future date when the item is created.  The formula I have set up for that is:  =[Date Required]&gt;TODAY()   This works well however I am running into an issue.  If the department is updating a List item after the Future Date it will still provide an error.  Is there a formula to use when the column validation can only be active when a new item is being created and not edited?    Thank you
100155
I would like to know how to send an e-mail in Outlook 2003 to a group of recipients in which each recipient will see only himself in "TO" field. You can see an example below;
27436
I would like to find a Python script that will access an attribute table within a shapefile and either update or replace records inside a field column. More specifically, I would like to use the replace expression to convert a table record like "123-456-789" to "123456789". I have many records to process and would like the best approach to do this task using Python.
105548
I make a new column in my attribute table and it has a default value (for example 0). I want to (probably using the field calculator) have the result that row 1 has the value 1, row 2=2 and so on, just like a numbered index.  I'd be thankful for a code example for the field calculator (including the use of $rownum (I think I need this for switching to the line)).
106917
This formula works fine when adding a new list item:  =[Class Date]>=TODAY()+3  Basically ensuring the user selects a date greater than two days away from current date.  I don't want the formula to be in effect if the record is an UPDATE to an existing record.  So if someone comes back to this record after completing it correctly and saving it, but now wants to update a different field I don't want this field to be editable nor do I want the validation formula to be applied to the updating of the record.  Is this possible?
39333
I have written a trigger to send email. Whenever the trigger is fired i am getting equal no of mails which is equal to no of records retrieved.  Ex - If i am getting 3 records, three times i am receiving email. Can anybody tell me where i am going wrong -  trigger taskEmail on Project__c (after update ) {     set&lt;String&gt; projName = new set&lt;String&gt;();     list&lt;Task__c&gt; listTask = new list&lt;Task__c&gt;();      for(Project__c pro : Trigger.new) {         projName.add(pro.Name);     }      listTask = [SELECT Id,Project_Approval__c,Project_Name__c,Status__c,Task_Executioner__c FROM Task__c WHERE Project_Name__c IN : projName];     system.debug('11111' + listTask.size());     EmailTemplate et=[Select id from EmailTemplate where name='Multiple Tasks'];     List&lt;Messaging.SingleEmailMessage&gt; mails = new List&lt;Messaging.SingleEmailMessage&gt;();      if(listTask.size() &gt; 0) {     system.debug('222222' + listTask.size());         for(Task__c con : listTask ) {         system.debug('33333  enter for ');                if(con.Project_Approval__c =='Approved' &amp;&amp; con.Status__c == 'Open'){             system.debug('444   enter if inside for ');              Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();             mail.setTargetObjectId(con.Task_Executioner__c);             mail.setTemplateId(et.Id);             mail.setSaveAsActivity(false);             mail.setWhatId(con.Id);             mails.add(mail);         }         system.debug('0000000');      }      Messaging.sendEmail(mails); } }
21955
In QGIS 1.8 I have a new column in my attribute table with a lot of NULL values and I want to replace all them to zeros. How can I do that in field calculator?
73530
In a Django form, how do I make a field read-only (or disabled)?  When the form is being used to create a new entry, all fields should be enabled - but when the record is in update mode some fields need to be read-only.  For example, when creating a new Item model, all fields must be editable, but while updating the record, is there a way to disable the sku field so that it is visible, but cannot be edited?  class Item(models.Model):     sku = models.CharField(max_length=50)     description = models.CharField(max_length=200)     added_by = models.ForeignKey(User)   class ItemForm(ModelForm):     class Meta:         model = Item         exclude = ('added_by')  def new_item_view(request):     if request.method == 'POST':         form = ItemForm(request.POST)         # Validate and save     else:             form = ItemForm()     # Render the view   Can class ItemForm be reused? What changes would be required in the ItemForm or Item model class? Would I need to write another class, "ItemUpdateForm", for updating the item?  def update_item_view(request):     if request.method == 'POST':         form = ItemUpdateForm(request.POST)         # Validate and save     else:         form = ItemUpdateForm()
112714
I need to set the minimum number of required values for several file fields in Drupal 7. I can only find options to make the field required or set a maximum number of allowed values. Is there any way to set the MINIMUM number of required values?
71203
I have created a domain exclusion DE with single field "Domain" and entered values for the field as "gmail.com".   Now how do I add this data extension to email under "User Initiated Email". I already tried selecting DE in Excluded DE but it didn't work. I already tried using domain value as "@gmail.com" but still it didn't work.   Can you please help me how to utilize this DE?
52829
I visited a question  and happened to get the newsletter registration prompt, which appears to have a styling issue in the email field:    The quick fix would be for the two fields to just have the same width (149px vs 200px), but it probably also makes sense at this point to just do away with the pseudo placeholders and just use the placeholder attribute universally, with a polyfill for legacy browsers.