For some reason, this seems to be a deep, dark secret of the Internet. Lesson completions are stored in the lifterlms_user_postmeta table. YMMV – You can try renaming that table if you don’t mind resetting all the completions…sometimes, that’s just the thing… This was related to a Groundhogg project, so sorry for the apparently errant…
There is way to do this in the current version of the Groundhogg LifterLMS extension. However, if you create a custom field, and implement this, from the always generous Poobah of Groundhogg, Adrian Tobey… You can set a Lead Score rule based on the value of the custom field.
In come cases, you may want to create multiple contacts from a single form submission, so that you can market to and track them separately. If you are selling a high value product or one with major life implcations, there may be multiple decision-makers. Or, you may want to capture multiple contacts from a team,…
Groundhogg.io is one of the top two CRMs for WordPress. It does a lot in the Core, and there are addons for functional requirements like Contracts, and technical/functional ones like Zapier integration. If you run a WordPress based site that has any business functions at all, you sell products, etc., I recommend you check it…
“Network for Good is a nice place to start, but once you are past startup phase, offers a terrible value proposition and lock-in.” We recently helped a client leave Network for Good (NfG) for a more powerful marketing automation plaform at a lower monthly cost. NfG is a fairly simple system which seems designed to…
“Modularity is Freedom. All-In-One is servitude. In technology, keep your options open, avoid lock-in.” We have created multiple systems that have delivered over $1 million USD in business value. It is easy to fall into the trap of various solutions we could call “all-in-one”, which intend to solve multiple issues for a paricular market. Our…
Thanks to Sully AND KEN the original source of the almost working query. Validation was substantially eased by EverSQL.com SELECTwpp.post_title,wpp.guid,wpp.post_date,REPLACE(REPLACE(REPLACE(REPLACE(wpo.option_value,‘%year%’,DATE_FORMAT(wpp.post_date, ‘%Y’)),‘monthnum%’,DATE_FORMAT(wpp.post_date, ‘%m’)),‘% day %’,DATE_FORMAT(wpp.post_date, ‘ %d ‘)),‘%postname%’,wpp.post_name) AS permalinkFROMwp_kympstfnsd_posts wppJOIN wp_kympstfnsd_options wpo ON wpo.option_name = ‘permalink_structure’WHEREwpp.post_type = ‘post’AND wpp.post_status = ‘publish’ORDER BYwpp.post_date DESC;
