Counter Existing Number

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    7 years, 12 months ago

    Does “old DB” mean a different database / WordPress site? Or do you mean in the same DB but under a different form name?

    In the first case you could try exporting the plugin table via PhpMyAdmin in the old DB then import into the new. In the second case, you could run a SQL statement to reame the field’s form name.

    The (nor free) CFDB Editor does export/import and renaming but I think your site will likely runout of memory doing 30k entries, so the PhpMyAdmin export/import might be best.

    Thread Starter primevitality

    (@primevitality)

    7 years, 12 months ago

    Yes, “old dB” means a whole different site/database. My hope was I just write a small line that takes the existing number of 30k and just simply adds it to the new database/site. I know it’s wrong, but something to the effect of [cfdb-count add=”30,023″ form=”the-pledge”]. Based on your answer it sounds like this isn’t possible. I don’t want to blow up the site by adding an additional 30k more people to the dB so I was hoping for a basic math formula to add into the count short code.

    Plugin Author Michael Simpson

    (@msimpson)

    7 years, 12 months ago

    If you just want to add on 30,023 to the total count, try:

    [cfdb-value form=”YOUR FORM” show=”submit_time” trans=”CountField(submit_time)&&submit_time=sum(submit_time,30023)”]

    Thread Starter primevitality

    (@primevitality)

    7 years, 12 months ago

    That worked perfectly. Thank you VERY much!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Counter Existing Number’ is closed to new replies.