Replacing a weekly email with perspective pages

An excel file schedule is being emailed with some notes in the body.

I thought this could be a perspective page and another perspective page could be used to edit and preview.

What has been working for such a replacement?

edit: I streamlined it my best.

That is one long post, a sure way to scare many forum readers :wink:

What you’re saying can definitely be done in Ignition, and quite easily at that. Where I work, we replaced a paper / Excel style of scheduling with Vision (and soon to be, Perspective) and it’s been working for the past 7-ish years that way. Data being stored in a DB is so much better to manage than many disjoint Excel files or, even worse, email threads.

This is definitely the way to go for you.

2 Likes

Thanks, that is really good to hear.

When you make the pages in perspective, do you plan to use mostly embedded views, or do you plan to switch views when you are navigating?

I am not sure which one tends to be faster performing.

You can adapt Ignition however you want. Based on what you’re describing, I would build it out on one page and if you need organization (e.g. the Excel tables you were talking about above), just use the Tab Container component to only show the user the data they want to see.

In my experience, if a page or view has many embedded views within it, performance suffers. It takes longer to load, you might see flickering on startup, etc. But I would test it out in your case.

Thanks

forgot about tab containers

will test

I started with the first summary.

I setup a text area on my manager page.

I bidirectional bound this to the tag, set for string.

It looks weird, but it is kind of working.

For some reason, in the text area, I can type lines.
They keep formatting.

When I bind to a label, the formatting goes out the window.

I think I have that kind of solved.

Instead of displaying from a label, I am displaying a text area with the alter text not enabled

I have suddenly become aware that I need to make a button that writes the temporary tags from the master page to the slave page.

Otherwise, all the editing will be live.

I would like someone with experience to help guide me on that.

I don’t know if I can just keep going without the button for now and add it later.

Or if it will be a big obstacle and should tackle it right now.

I think I better start with the button now. It will slow down testing, but I think it might be better overall.

I think the way this forum works, it has a preview on the right. I will probably have a preview on the manager page in a another flex container.

Is there a way I can enable users to use bold, colored text, and font size adjustments in the text area component for perspective?

The email is rather vibrant.
The text area I setup on the ignition page is simple right now.

I think you'll get more feedback if you have some screenshots of what you have currently, as that wall of text is a lot to go through :roll_eyes:

You can try adding HTML mark-up, but I don't know if the text area component supports it. You would have to use the markdown component I think Perspective - Markdown - Ignition User Manual 8.0 - Ignition Documentation but it's not an input field.... There's no rich text editor component for Perspective that would do what you're after

@nminchin

Thanks for confirmation that such a component doesn’t exist yet in Perspective.
I was thinking I have to set the vibrant text requirement to the side until such an input component exists.

I might revise that top post.
Just had an idea an email to start.

What component(s) are recommended for generally replacing an excel table in perspective?

I was going to use a ton of flex containers and text areas because I am not sure what components will allow me to edit from the perspective page.

I am concerned about:
archiving, date range changing, date range limiting

oh you can set the table objects to editable

I see

This is a little confusing. Please can you elaborate a little further on this. As @nminchin stated, please provide images, etc. and context wherever possible (for example, what are the master/slave pages? what are the temporary tags?).

99.9% of us are on here in our spare time, so posts/threads that are unconcise, hard to understand, or very long will likely go ignored (because it takes too long to figure out what the issue is). We're here to help, but it's only human nature to go for the easiest problem first :slight_smile:

Anyway, it looks like you have come across the Table component, which is best placed to do:

1 Like

are there more tutorials on the table component?
I saw a short one, but I need a lot more information on working with it I think.

I did my best to streamline the original post.
Right now, I am trying to learn how I can use the table to replace an excel file.
I will take a picture, but I don’t think it is useful.

oh no
it is going sideways

I am not sure why, but I only have one column while I see in the example video that he has 3 columns.

columns visible was checked?
now that it is unchecked, the columns are visible?

my columns are getting reordered and I do not wish that to happen
just now, my line went to the third column?
I am not sure why

I am getting really odd and seemingly unpredictable performance from this table.

The columns are moving around faster than I can edit them.

The visible toggle seems backwards to me as posted above.

Are people using the table component because I am getting seemingly random behavior from this component?

Maybe someone is editing this specific table on my project simultaneously to me.
Is it possible to see if someone else is editing the same object I am working on?


after testing, if I type in a new value, whatever change I make, the columns are reordered