I have created 2 tables, both tables are on 1cpage on the website. I needed one Total from the 1st table to pull into a formula on the second table. I activated the parse shortcodes, checked the configs. The result after entering the shortcodes into the desired cells is always 0 and not the total value from the 1st tables Total. Can you please advise on what I can check or do?
Unfortunately, the column's shortcode cannot be used like that.
When you enable the "Parse shortcodes in strings" that means you can pass the shortcodes in String-type columns' cells values, not in Formula columns.
The reason you're getting a "0" as a result is because the Formula column cannot see the value, but instead sees the whole shortcode as a string, and per our documentation:
Only numeric columns are allowed (non-numeric will be parsed as 0).
In the documentation, you can also see that one of the limitations of those columns is that adding a sum in the sum row for formula columns is not yet supported. This limitation has the same background as to why it's not possible to use the shortcodes in it.
Is there a way that a user(front end) value that automatically carries through to the entire column? In this case it is an exchange rate and the table is a price list, we import a few items upon ordering so sales people would need to enter our current rate of exchange into a single cell, the unit price is a fixed value so they would need to enter the ROE and then the desired quantity.
ROE x Unit price x Quantity = Total(Formula column)
Basically, we enter the ROE into one block and that exact value applies to every cell in one column?
I have created 2 tables, both tables are on 1cpage on the website. I needed one Total from the 1st table to pull into a formula on the second table. I activated the parse shortcodes, checked the configs. The result after entering the shortcodes into the desired cells is always 0 and not the total value from the 1st tables Total. Can you please advise on what I can check or do?
Hello Gavin.
Unfortunately, the column's shortcode cannot be used like that.
When you enable the "Parse shortcodes in strings" that means you can pass the shortcodes in String-type columns' cells values, not in Formula columns.
The reason you're getting a "0" as a result is because the Formula column cannot see the value, but instead sees the whole shortcode as a string, and per our documentation:
Only numeric columns are allowed (non-numeric will be parsed as 0).
In the documentation, you can also see that one of the limitations of those columns is that adding a sum in the sum row for formula columns is not yet supported. This limitation has the same background as to why it's not possible to use the shortcodes in it.
Sorry for the inconvenience.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
thank you for the response.
Is there a way that a user(front end) value that automatically carries through to the entire column? In this case it is an exchange rate and the table is a price list, we import a few items upon ordering so sales people would need to enter our current rate of exchange into a single cell, the unit price is a fixed value so they would need to enter the ROE and then the desired quantity.
ROE x Unit price x Quantity = Total(Formula column)
Basically, we enter the ROE into one block and that exact value applies to every cell in one column?
Does that make sense and is it somehow possible?
Hey Gavin.
I understand what you want to do, but unfortunately something like this is not possible with the plugin's built-in features.
On front-end, users are able to enter only one row at a time. Unfortunately, I don't believe there's a workaround for this.
Sorry for the inconvenience.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables