Support

Search results for ""

Sorry, no results found. Perhaps you would like to search the documentation?
All Topics
Eugene

Calculated Column or Formula Column

I would like to have a column type that allows me to build a calculated column using a formula style syntax and that allows me to use columns from the WP database.

For example:

Concatenate(“<a href=”‘?ID=“,”%ID%”,”’” target=”‘_newwindow’”>”,%display_name%,”</a>”)

Or something similar.

7 years ago
Stefan van den Dungen Gronovius
Developer

Hi Eugene,

As a developer I like the idea, but I think such a column will be too complex for most users and does not really fit our plugin. We’ll have to think about a syntax for the calculation that could be used safely from the admin overview etc. Maybe when I have some spare time, I will think about a solution and share it with you.

In the meantime you could consider to use one of our filters where you can alter the value and do you own calculation in code. https://www.admincolumns.com/documentation/filter-reference/ac-column-value/

Or you could decide to work on your own column by using our column toolset.
https://www.admincolumns.com/documentation/guides/creating-new-column-type/

7 years ago
Eugene

checking back to see if any progress on this topic or others interested in the same thing. One thing I use Calculated Column for heavily in our intranet SharePoint environment is to make hyperlinks with various details in the <a> tag. This way I don’t have to code up a web page and custom web part (equivalent to WP PHP filter, Java applet, or widget).

I didn’t get to look at the filter article yet. Looking now.

6 years, 5 months ago

You must be logged in to reply to this topic.