Other

Comments

Post a Comment

Popular posts from this blog

Whitelist an Azure firewall IP using PowerShell

  1. Connect via PowerShell in Azure portal: PS /home/azureuser> Connect-AzAccount -UseDeviceAuthentication 2. Run in PowerShell: PS /home/azureuser>$new_ip = (Invoke-WebRequest ifconfig.me/ip).Content; Set-AzSqlServerFirewallRule -ResourceGroupName "<res_group_name>" -ServerName "<server_name>" -FirewallRuleName "test" -StartIpAddress "$new_ip" -EndIpAddress "$new_ip";
Read more

Django: Avoid "This field is required." message in the custom admin view.

Problem:  Avoid " This field is required. " message in the custom Django admin view when trying to save an object. Solution: blank=True  for the corresponding field in  models.py  will allow you to save an object without that field filled in when trying to save an object. For example: my_year = models.DateField(null=True, blank=True)
Read more

Excel: highlighting a row or a column based a value, the current date example.

Image
Sometimes you need to to be able to look at your spreadsheet and quickly see the row or column relate to a certain value. Conditional highlighting will definitely help with that. I will show using the current date as an example. Select the working range. Go to Conditional Formatting. Set the formula: The dollar sign ($) will anchor either a row (A$1) or a column ($A1), so that the formula will be applied to, respectively, all the columns in the anchored row or all the rows in the anchored column.  Click Format and select the highlighting effects that you need. Click OK and observe the highlighted row or a column:
Read more