Set up auto increment column for serial number

Hello @growbusiness,

Did you want something like this?

https://ibb.co/xD5kdpd (or) https://ibb.co/FKZ8kCC

• This reply was modified 2 years, 7 months ago by Essekia.

yes exactly like this
But auto increment sequence number after getting new entry from Form Submission

@growbusiness Ok got it. Will get it done very soon.

Other than this, may I know how you are liking Tablesome?

PLZ provide given feature as soon as possible

And about this plgin…..
Its AWESOME plugin
I had been looking for that kind of plugin for almost a month and almost try 10+ plugins. But none of them provide such kind of table options and if some plugins have features then they don’t get data after form submission.
This is BEST and I’m going to use this plugin for my other websites too.
A BIG THANKS ??

@growbusiness Love your feedback!

We will look into the technical aspects (to not break anything while implementing this) and get this done asap.

Once the update is released, please do consider leaving your experience as a review. It would help people like you looking for a solution.

Date Column display wrong date (just 1 January, 1970)

As I mention before, after form submission data display in table but in date column it always show default date i.e. January 1, 1970

Here is screenshot of error (Last 2 rows)

https://janpathpalace.com/wp-content/uploads/2022/04/Screenshot-2022-04-09-at-16-51-26-Inquires-–-Janpath-Palace.png

• This reply was modified 2 years, 7 months ago by growbusiness.

@growbusiness

1. What was the value entered in the form?

2. Or do you want to automatically store the date of form submission?

If it’s the latter, it’s also currently not available but scheduled for release this month. Will try to accelerate this.

• This reply was modified 2 years, 7 months ago by Essekia.

1. New value entered 20 June 2022 (other values import from previous table)

2. YES

Other rows are working fine (accurate data) expect date column. It always show January 1, 1970

@growbusiness Can you send me the screenshots of

1. Triggers and Actions
2. Form

Will look into this as well.

Action

https://janpathpalace.com/wp-content/uploads/2022/04/action.png

Form View (Its WPForm)

https://janpathpalace.com/wp-content/uploads/2022/04/form.png

Data saved in table created by Tablesome Plugin like this (Last two rows are from form submission which saves correct date but view on table is different VIEW https://janpathpalace.com/wp-content/uploads/2022/04/Screenshot-2022-04-09-at-16-51-26-Inquires-–-Janpath-Palace.png
Whereas upper rows where imported data is saved have different format to save date)

Data saved in table

https://janpathpalace.com/wp-content/uploads/2022/04/table.png

At start, I was using WPForms Views Plugin and it showed correct date after form submission but lack of features I switched to your plugin.

• This reply was modified 2 years, 7 months ago by growbusiness.

@growbusiness Thanks for trying Tablesome. We will fix these issues very soon.

Tablesome is being actively developed, feel free to share your suggestions and feature requests anytime.

@growbusiness This issue has been fixed. Will be released in v0.7.1 (coming today or tomorrow).

Hi @growbusiness

1. The issue with the date format has been fixed in our latest release. Can you please update to V0.7.1 and check if this issue has been resolved on your end. I recommend you to update in your staging site first before updating it in Live site.

2. S.NO Auto-Increment order has also been implemented in the current release.

Looking forward to hearing back from you.

Kind Regards.

Thank You so much for resolving this issue and adding new brilliant functions

But it was getting delay so I simply updated some code for date error on particular column

// path: wp-content / plugins / tablesome / includes : actions.php

public function print_tables_collection()
{
global $tablesome_tables_collection ;

try{
foreach($tablesome_tables_collection[0][‘items’][‘rows’] as $key => $row) {
if(is_numeric($row[“content”][6][“html”]) == false) {
$timestamps = strtotime(($row[“content”][6][“html”])).”000″;
$tablesome_tables_collection[0][‘items’][‘rows’][$key][“content”][6][“value”] = $timestamps;
$tablesome_tables_collection[0][‘items’][‘rows’][$key][“content”][6][“html”] = $timestamps;
}
}
}catch(\Exception $e) { }

$script = “<script>”;
$script .= “window.tablesomeTables = ” . json_encode( $tablesome_tables_collection ) . “;”;
$script .= “</script>”;
echo $script ;
}

After updating plugin, New entries show right date but previous dates didn’t show properly ??

So for this, I simply download form entries and re-create a new table, Now its working fine.

Here is one more thing

If person update form entry e.g. changing client name or delete an entry from WPForm entry management section,
But data in table at frontend remain unchanged