Michael Simpson

1. https://cfdbplugin.com/?p=867

2. You will have to do something with css on that page, which is affected by your theme css. Maybe add to your shortcode id="mytable" style="#mytable { width: 100% }"

Q1:
If you are talking a million entries, you might need more memory. It depends on #rows times #columns times how much data in each field.

Q2:
If a person is logged in when he submits a form, then his login name is captured in the “Submitted Login” field.

We can use CountField to count like below:

[cfdb-table form="YOUR-FORM" show="user,Submitted Login" trans="user=strval(Submitted Login)&&CountField(Submitted Login,user)&&SortByField(Submitted Login,DESC)" headers="Submitted Login=count"]

add limit=”1″ to get just the top scorer.

In Trans:
– user=strval(Submitted Login) I create a copy of what is in “Submitted Login” as a new column “user”. Because I need two different column names in CountField (probably I should fix that code)
– CountField(Submitted Login,user) Counts the entries for each user. The count ends up in Submitted Login field.
https://cfdbplugin.com/?page_id=1167
– SortByField sorts by the count, descending so largest first
– “show” orders the columns
– “headers” renames “Submitted Login” to “count” to be less confusing

Update what, exactly?

Let’s back up, if you have a form named “FORM” and a field called “UPLOAD” where people uploaded file, then you could put a shortcode on a page like:

[cfdb-html form="FORM" show="UPDLOAD" filelinks="link"]
${link} <br/>
[/cfdb-html]

Then you should have clickable links to uploaded files.

In the security settings, you would set “Can See Submission data when using shortcodes” to “Anyone” so you don’t need to login to see it.

I think you have to override those style either in you own style sheet or in the shortcode. Something like this might work:

[cfdb-table form="YOUR_FORM" id="mytable" style="#mytable td > div {max-height: none !important; overflow: none !important;}"

I think this is a WordPress thing. If it does not execute shortcodes, then I don’t think there is anything we can do about it. Do regular shortcodes (not created with this plugin) work there?

It looks like none of the Javascript is being loaded on the page. The shortcode tells WP that it needs some scripts loaded. But I think in this case, since the shortcode is being loaded in a round-about way, that by the time the shortcode is called, it is too late to add the scripts. So you don’t get any of the datatable decoration (like search field) or editability.

I think that if you look at the HTML for that page, you will NOT see “cfdb.edit.js” in it. But if you just put that shortcode directly in a post, then you do. Would you verify that hypothesis?

I’d have to work through this example and see if there is a way to make my plugin inject the scripts in that scenario.