Skip Navigation

[Resolved] Can I use Toolset to build an editable datasheet?

This support ticket is created 5 years, 11 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 -
- 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 -

Supporter timezone: Europe/London (GMT+00:00)

Tagged: 

This topic contains 1 reply, has 2 voices.

Last updated by Nigel 5 years, 11 months ago.

Assisted by: Nigel.

Author
Posts
#1220026

I would like to display all the records (rows) in a front-end datatable, with the fields being editable. Example:
┌─────┬──────┬──────────┐
│ Adams │ Andrew │ Active member │
├─────┼─────┼───────────┤
│ Backer │ Barron │ SuspendedTmp │
└─────┴─────┴───────────┘
With each row being edited in place. The displayed table would contain all records in a vertical scroll, and as a bonus would be searchable (although Ctrl-F should work fine for this).

Can I do this in Toolset?
I have read the documentation at
https://toolset.com/documentation/getting-started-with-toolset/publish-content-from-the-front-end/forms-for-editing/
but did not find the answer there.

Thank you.

#1220255

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi David

No problems displaying the data in such a format, but you cannot edit the content in place, you need to go to a Form that contains the fields of a whole row, for example, submit changes, and then return to the same page.

If you really want the editing-in-place functionality for tables you may find a solution based on something like a spreadsheet.

I know, for example, that there has been some work on integrating Airtable with WordPress, and there could be other solutions using Google sheets or similar, whereby users make changes to a spreadsheet or similar, and these are then synced back to fields in the WordPress database.

That's outside the scope of what Toolset offers, but if you research you may find a solution along those lines that fits your needs.