Title: Single Cell Content Shortcode
Last modified: May 9, 2020

---

# Single Cell Content Shortcode

 *  Resolved [PolyWogg](https://wordpress.org/support/users/polywogg/)
 * (@polywogg)
 * [6 years ago](https://wordpress.org/support/topic/single-cell-content-shortcode-5/)
 * Similar to the request at [https://wordpress.org/support/topic/combine-filters-and-single-cell-reference/](https://wordpress.org/support/topic/combine-filters-and-single-cell-reference/)
   where the person wanted to combine filters and single cells, I too want to be
   able to do something similar, which I see can’t be done.
 * Let me explain what I want to do. I’m an astronomer, and I’ll looking for a way
   to record my observations in the field on my phone. One of the challenges for
   that is that white light destroys your night vision, so you pretty much have 
   to eitehr apply a strong red filter option in the accessibility section OR design
   a screen that has all black layout with red text (red light doesn’t kill your
   eyes). But once I get that data from potentially a form, I can get it into Table
   Press and store it ready for WordPress display. But we’re talking some 50 fields.
   I only want to be able to show one row at a time, and to layout it out nicely
   in a post. I was thinking, as the other person did, that if I could filter it
   down to one line, and then code it accordingly, all good. Since that won’t work,
   I’m on to other options.
 * My coding skills are rudimentary, but I was essentially wondering if there would
   be a way to assign a variable at the start of a page, say observation=4, and 
   then later say:
 * [table-cell id=123 row=$observation$ column=3 /]
 * or equivalent. As long as the table was in proper raw format, it would be the
   same as filtering.
 * Others have suggested taking the data and putting it in something like Google
   Sheets to pull from, but I feel there is / should be a way to show an entry. 
   I feel like we’re trying to push TablePress’ flat-file format into a database
   report layout, or a form layout, so if there are better ways to integrate TablePress
   with other plugins that can pull from TablePress, happy to consider them.
 * Any suggestions?
 * Paul

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years ago](https://wordpress.org/support/topic/single-cell-content-shortcode-5/#post-12816017)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * Just to confirm: You are trying to change how the output looks like on the frontend
   part, where you view the table (or just parts from it)? Or are you trying to 
   change how things look like on the table’s “Edit” screen (where you add new data
   or edit it)?
 * Now, a parameter/variable could be possible if you use a wrapper Shortcode. For
   example, add this to the “functions.php” file of your site (or the PHP file for
   the Single Cell Shortcode Extension):
 *     ```
       add_shortcode( 'observation_table_cell', 'polywogg_tablepress_cell_observation' );
       function polywogg_tablepress_cell_observation( $atts ) {
         if ( empty( $_GET['observation'] ) ) {
           return;
         }
         $atts['row'] = absint( $_GET['observation'] );
         return tablepress_table_cell_shortcode( $atts );
       }
       ```
   
 * This will then add a new Shortcode that you can use on your pages, like
 *     ```
       [observation_table_cell id=123 column=3 /]
       ```
   
 * The `row` parameter will be automatically filled from a parameter in the URL,
   in this case the `observation` parameter. Thus, if you then open that page with
   that Shortcode on a page like
 *     ```
       https://your-site.com/page-with-table/?observation=4
       ```
   
 * that number will automatically be used for that `row` parameter.
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Single Cell Content Shortcode’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/single-cell-content-shortcode-5/#post-12816017)
 * Status: resolved