Accordion( NumberedList; selectedGroup; showNumbers )
Rate this function: Average rating: 4.4 (7 votes) Discuss this Custom Function
Bruce Robertson, Concise Design
http://concise-design.com
Given a numbered list and a selected group number, collapse all items in unselected group.
Sample Input:
Let( thisList = "1.0 Vegetables¶1.1 Peas¶1.2 Brocolli¶1.3 Brussel Sprouts¶2.0 Fruits¶2.1 Apple¶2.1 Pear¶2.2 Peach";
Accordion( thisList; 2; "")
|
|
Sample Output:
Vegetables
Fruits
Apple
Pear
Peach |
|
Description:
Given a numbered list n.0, n.1, etc and a selected group,
collapse all items in unselected group.
You may pass group number or value of item 0 of selected group
1.0 Vegetables
1.1 Peas
1.2 Brocolli
1.3 Brussel Sprouts
2.0 Fruits
2.1 Apple
2.1 Pear
2.2 Peach
example:
Let( thisList = "1.0 Vegetables¶1.1 Peas¶1.2 Brocolli¶1.3 Brussel Sprouts¶2.0 Fruits¶2.1 Apple¶2.1 Pear¶2.2 Peach";
Accordion( thisList; 2; "")
result:
Vegetables
Fruits
Apple
Pear
Peach
Example file:
http://concise-design.com/downloads/accordion.zip
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
webviewer_button ( content; textCol; bgCol ) |
| |
(Wed, Mar 03, 11:18am) |
| 2. |
RemoveCommonValues ( Array ; ComparisonArray ) |
| |
(Wed, Feb 24, 9:39pm) |
| 3. |
DistanceGeoCoord ( Lat1deg ; Lat1mm ; Lat1ss ; Lon1deg ; Lon1mm ; Lon1ss ; Lat2deg ; Lat2mm ; Lat2ss ; Lon2deg ; Lon2mm ; Lon2ss ; U ; Version ) |
| |
(Wed, Feb 24, 2:20pm) |
| 4. |
fnGoogleLineChart ( chtitle ; xtitle ; ytitle ; xfield ; yfield ; color ) |
| |
(Tue, Feb 23, 1:30pm) |
| 5. |
StringConstruct ( text ; prefix ; suffix ; altText ) |
| |
(Fri, Feb 19, 10:57am) |
| 6. |
ShowValueCascade ( fields ; altText ) |
| |
(Fri, Feb 19, 10:44am) |
| 7. |
ShowValue ( text; altText ) |
| |
(Fri, Feb 19, 10:28am) |
| 8. |
timeFormat ( thetime ; leader ) |
| |
(Wed, Feb 17, 7:44pm) |
 |
|