• Ellen_e
  • NEWBIE
  • 0 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 2
    Replies

Hello,

 

I am building a VF page for the purpose of easily navigating custom reports. I am just starting to learn code and could use an extra set of eyes to help identify my errors.

 

The two issues being:

 

1. The third layer of the menu is not appearing upon hover (I have tried many combinations of css code)

2. The initial link opens in the iFrame, but the 2nd later links open as separate tabs.

 

<apex:page sidebar="false" showHeader="false">
     <body>
    <html>
    <style>

.top head {font-size: 40px; text-align: center; font-family: Verdana, sans-serif;}

.nav ul {list-style: none; margin: 0px; font-family: verdana, sans-serif; text-align: center;}

.nav li {float:left; width:200px background-color:#444444; text-align: center; 
          boarder-right:1px solid white; position:relative; height:30px; line-height:30px;}

.nav li ul li {float:none; width:200px; text-align:center; padding-left:5px; boarder-tip:1px solid white;}

.nav a {text-decoration:none; color:black; text-align: center;}
.nav li ul {position:absolute; top:30px; left:0; visibility:hidden;}

.nav li:hover {background-color:yellow;}
.nav li:hover ul {visibility:visible;} 

<body>

<div class="nav">

<ul> 
    <li>  
        <a> Summary </a>
        <ul>
            <li><a href="www" target="theIframe">Volume </a></li>
		<ul>
			<li><a href="www" target="theIframe">Overall</a></li>
		</ul>
            <li><a href="www" target="theIframe"> ASP </a></li>
        </ul>

</ul>
</div> 

 <br/><br/><br/><br/>
       <iframe src="www" scrolling="true" id="theIframe" width="90%" align="center"/> 
     

</body>
</html>
</apex>

  I really appreciate any help or links to further resources!

Hello!

 

I have a large amount of data that needs to be cleaned up through salesforce inorder to create reports. There are numbers in the following formats:

 

                                            ABC##x##ABC, ABC-####-ABC, ABC100mABC, ABC100MABC

                                                   The ABC* represent text strings of varying lengths.

 

I would like to "pull out" the areas numbers/ text I idicated in blue in a seperate filed,

 

I have created a formula field as follows:

 

IF(CONTAINS("x", Item_Name__c), MID(Item_Name__c, FIND("x", Item_Name__c), 5), IF(CONTAINS("100M:100m", Item_Name__c), "100m", IF(CONTAINS("1630", Item_Name__c), "16x30", IF(CONTAINS("2040", Item_Name__c), "20x40", IF(CONTAINS("3050", Item_Name__c), "30x50", IF(CONTAINS("4070", Item_Name__c), "40x70", NULL))))))

 

When I uploaded the data however, the formula did not work and returned only "blank" values. I am worried it is too complex or incorrectly formatted. Any help or suggestions would be greatly appreciated!

 

Thank you.

Hello!

 

I have a large amount of data that needs to be cleaned up through salesforce inorder to create reports. There are numbers in the following formats:

 

                                            ABC##x##ABC, ABC-####-ABC, ABC100mABC, ABC100MABC

                                                   The ABC* represent text strings of varying lengths.

 

I would like to "pull out" the areas numbers/ text I idicated in blue in a seperate filed,

 

I have created a formula field as follows:

 

IF(CONTAINS("x", Item_Name__c), MID(Item_Name__c, FIND("x", Item_Name__c), 5), IF(CONTAINS("100M:100m", Item_Name__c), "100m", IF(CONTAINS("1630", Item_Name__c), "16x30", IF(CONTAINS("2040", Item_Name__c), "20x40", IF(CONTAINS("3050", Item_Name__c), "30x50", IF(CONTAINS("4070", Item_Name__c), "40x70", NULL))))))

 

When I uploaded the data however, the formula did not work and returned only "blank" values. I am worried it is too complex or incorrectly formatted. Any help or suggestions would be greatly appreciated!

 

Thank you.