Hello,

To begin, I want to extend my heartfelt apologies for the delayed reply, 

which is due to an unexpectedly high volume of inquiries. 

We truly value your patience during this period.

-

1. In regards to using hex code in a field, i presume that code will be coming from your source cell from the Google Sheet?

if that is the case, sorry to disappoint you, but any formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.

Please check the full list of limitations for our Google Spreadsheet Tables here.

-

If you need to set up some color/background color or add a custom CSS class based on a value from a field, please check our Conditional Formatting capabilities here.

If you add a custom CSS class with a Conditional Rule, for example to a cell, Column, a row etc;

You can then call that CSS class and add custom styles, if you need it only for one Table, add it to the Table's Customize/Custom CSS, 

 or if you wish to add a global custom style which is called for any Table that has that class, add the style to main plugin settings/Custom JS and CSS/Custom CSS.

2. If you have any Formula in the Sheet that provides the data for the cells, please check our Guide here, how to use a Google Sheet with Formulas and out Plugin.

In short, it is adding a new blank Sheet Tab with !importrange in Cell A1,  then using that Sheet to connect to our Table and provide the 'finished values' after the Formula.

I hope that helps.

Hello,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

If i understood, with the Ninja Tables, you can somehow just input the hex color value from your Source Sheet cell, and the Table automatically recognises that it should color the cell just like that?

Sorry, but in our Plugin that is not possible.

As i mentioned earlier, these are the capabilities with our Plugin when you need to place colors on any cells :

any formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.

Please check the full list of limitations for our Google Spreadsheet Tables here.

-

If you need to set up some color/background color or add a custom CSS class based on a value from a field, please check our Conditional Formatting capabilities here.

If you add a custom CSS class with a Conditional Rule, for example to a cell, Column, a row etc;

You can then call that CSS class and add custom styles, if you need it only for one Table, add it to the Table's Customize/Custom CSS, 

 or if you wish to add a global custom style which is called for any Table that has that class, add the style to main plugin settings/Custom JS and CSS/Custom CSS.

2. If you have any Formula in the Sheet that provides the data for the cells, please check our Guide here, how to use a Google Sheet with Formulas and out Plugin.

In short, it is adding a new blank Sheet Tab with !importrange in Cell A1,  then using that Sheet to connect to our Table and provide the 'finished values' after the Formula.

I hope that helps. 

Let me know if you have any additional questions, if you try any of these methods and if you need help with any of the details to set colors in our cells.