Db9 Pin Numbering

0 views

Skip to first unread message

Annemie

unread,

Aug 3, 2024, 11:10:55 AM8/3/24

to exewinel

I have a feature layer of named buildings that are categorized based on use, ie Food & Drink, Hotels, Shopping, etc. I want to have a Key Numbering system setup where Food & Drink are orange and go from 1 - whatever, and then Hotels in green going from 1 to whatever. Essentially I want it to start from 1 for each category. I also want the number to show up in a the appropriate colored circle. View the attached image for an example. I don't want to do it all manually in Illustrator is essentially what I'm saying. How do I go about doing this?

A similar post is here: Key numbering list placement Another way to describe what I want to do is based on the image in their post; I'd like the numbers to reset based on the color. For example the pinks would be from 1-3, orange 1, and so. They would all be in their own lists, and the number would actually show up in the circle.

I have seen a few posts on this forum from years back which have requested this feature, with confirmation from Smartsheet employees that this was in the works ( -numbering), so it I find it surprising that this still hasn't been done.

In my humble opinion, this solution doesn't work, the numbers are NOT what I would expect from a WBS. EDIT!!! After posting this I went back to the sheet where I took the above screen grab and it had saved and amended all the WBS code to a code that WAS Correct!! Weird that it saved like this first though!

APOLOGIES - I noticed my screen shot above has incorrect Level4 within the numeric only code, that is due to me only coding up to level 3 in that column! I only developed this as an exercise for myself! I went up to Level 4 in the Alpha and level 3 in the numeric. Have adapted the IF to state no level 4!

@Debbie Sawyer, thank you also for the screenshots above, I agree that the solution in the thread shared by Andre does not match what I would expect from a WBS. I will take you up on your kind offer for a sample of the sheet you're currently using, as it looks to be exactly what I was hoping for.

as helpful as the workarounds shown here are, I'm really wondering if this isn't a function that Smartsheet can integrate? It's been talked about for a couple of years already! We are using one of the workarounds on a 1000-line long sheet and it's making it extremely slow in updating the formulas...

@Debbie Sawyer I found this thread in Smartsheet community and was wondering if you still had the sample sheet available to share? I am trying to create something similar and would like to incorporate letters as you have shown here. Thank you.

WBS is just a name for listing your tasks out in a sheet. It is the Work Breakdown Structure. i.e. you are structuring your work to allow you to track its progress. This thread is detailing how the rows are numbered automatically to allow you to reference tasks within the sheet.

You are most probably already implementing a WBS in your Project Sheet without realising it! If you have something like a phase heading followed by all the tasks that you need to complete with that phase of work, then you indeed have a work breakdown structure in your sheet.

I opened a support ticket, but I can't close this pop-up no matter what I click or what browser I use and I'm wondering if anyone has any insight. I'm LOCKED OUT of my work because of some stupid UI refresh alert. ?

Chapter numbering and Toggle Numbered List are incompatible and conflicting attributes. With the list button, you create lists, which is a contiguous sequence of numbered items (this is simplified for a quick explanation). When you enter your second Heading 1 and turn on numbered list mode, you create a second list which has its own sequence of numbers as you would expect for different lists.

You were right in setting properties in Tools>Chapter Numbering. They apply to the Heading n family of styles. There nothing more to do. Just use the Heading n styles and your chapters will get numbered.

It was instead of the ordered list, the No List option was activated and by pressing on it I was not able to deactivate it. I do not remember activating this option but I was working on this document for quite some time, hence my memory is fuzzy.

Could you, please, elaborate a bit? Such a stance should not be necessary. Edit your answer to mention OS name and LO version, perhaps save format. Describe with more details how your headings are configured. If you used toolbar buttons to add numbering, this is an error.

Dear Affinity Support Forum,

I am trying to find a feature that allows me to automatically number my figures / images / tables that I added to my text to reference them and to add them to my table of figures. I couldnt find a tutorial on this topic and my search in this forum hasnt been too succesfull as I could only find this older entry from 2018. Is there a way to number images like I can number my pages?

I am trying to find a feature that allows me to automatically number my figures / images / tables that I added to my text to reference them and to add them to my table of figures. I couldnt find a tutorial on this topic and my search in this forum hasnt been too succesfull as I could only find this older entry from 2018. Is there a way to number images like I can number my pages?

You can define a paragraph text style for a caption line below your figures, and call it whatever you want. Here I've used Figure Numbers in Body as the paragraph text style name. Then in the Bullets and Numbering section you need to assign the numbering text that will be used (e.g., "Figure \#"), and a global name for the number so it can increment throughout the document. Note that the numbers will run sequentially throughout the document (though you could change that), and on each page will increment within each text frame, and from the bottom up in the Layers panel. That is, when you create a text frame for the figure caption, and then create another one on that page, the one that is lower in the Layers panel will have a lower number than the one that is higher in the Layers panel.

You can later create a TOC to act as a list of Figures, and in that TOC you can include the paragraph text style that you used in the figure captions. This will automatically pick up the related figure number as part of the TOC text.

I think you have to do it manually, today, with different Bullets and Numbering settings. E.g., for the items in chapter 1, use "Fig. 1." for the text before the number, and for chapter 2 use "Fig. 2."

The North American Numbering Council (NANC) is a Federal Advisory Committee that was created to advise the Commission on numbering issues and to make recommendations that foster efficient and impartial number administration.

Only the devs can do this, I think, since this requires modifying JavaScript. You could mess with the internals of Obsidian, of course, but the external interface allows us to modify the CSS, but not JS.

In my opinion these should all be merged since they all deal with the fine-grain control of MathJax. If these are implemented 1-by-1 I worry that the solution will be a bit inflexible. Since MathJax is a core feature I think these should be also, but if not this topic should motivate the plugin API to be able to handle these use cases.

Anyway, the whole equation numbering issue is unworkable in Obsidian. If one has to put in the numbers with tag1, the elegance and power of Latex equation numbering is lost. The whole point is to avoid manual numbering.

Obsidian is very well done in general. It is a rare markdown editor for which I do not have the urge to change its default settings. However, the lack of auto-numbering is a significant drawback. I hope the developers are still working on a full MathJax support.

I recently achieved something similar with sequential numbering of the custom objects upon creation. This is achievable by creating a private app and using the HubSpot API. The search endpoint returns a JSON with a total of records. Adding formatting to the workflow to add 1 and save within the property. Happy to share code examples if it helps.

While the workaround you have suggested will work, I'd be hard pressed to understand why such a simple functionality (surely the basic code is publically available) can't be quickly turned around by the HS Dev team.

So far, I am not seeing how to do this (or if it can be done). I realize that sharing the autonumber will still create unique IDs for each order, but part of the problem we are trying to solve is for people out in the field to know that they have their own set of numbers and if they need to place an order with their vendor but are not near the computer, then just have to remember the last available number in sequence to give a PO # to the vendor. If everyone shares, then you never really know what the next available number is since anyone could take it.