[jasecorn]

I use XCrud. Bit of a learning curve, but powerful.

Jason.

[jasecorn]

Thanks Ally. This one sounds a little out of my league. Would love to see the option in v2 however.

Jason.

[jasecorn]

Ally, you rock 🙂

Thanks for that. This works perfectly!

[jasecorn]

Hi Ally

I should have mentioned that I’m using an external database with an auto increment ID. The database needs to be portable, so living within the wordpress database isn’t really an option.
Looking at the code you have provided, I’m assuming it relies on storing the data in the wordpress database, and utilising the “Entry ID” field?

Jason.

[jasecorn]

I’m using this method to populate a drop-down.
I was wondering if it’s possible to extend this further by auto filling another field via an SQL query based on the value selected in the drop-down.

For example;
SQL table contains products, and I have these populate the drop down.
Another field in the table contains whether the product is in stock or out of stock.
I want a separate field in the form to populate the stock status.

I know I could display the stock status next to the product in the existing drop down with a CONCAT query, but I specifically want it to populate a different field. My reasoning is that I want to save this data into a completely different database table, and the two values need to be in different SQL columns. A CONCAT would put them into the same column.

Would this be possible?

[jasecorn]

Awesome! That works great. Thanks 🙂

[jasecorn]

Hi Ally

I just noticed that while this works great initially, with the form set to “Display a message” after submitting the form, the date field is reset to the default (d/m/y) when a form is submitted – so it loses the date completely after the first submission.
Is there any way to make this stick after submitting a form?

[jasecorn]

Thanks for that!
Although I think you meant to use .getDate() instead of .getDay()?
.getDay returns the days of the week instead of the month.

[jasecorn]

Hi

Is there a way to change the timezone offset for this? It appears to be getting today’s date from the server, instead of from the users’s local PC.

[jasecorn]

Thanks Ally
I’ve been reading up for the last 3 days to try and get this to work, but unfortunately I don’t have a background in coding, so I’m failing dismally.
I’m assuming I need to tie it to the jqueryui autocomplete function, and from what I’ve read it should be pretty simple.
I know it’s not really a function of this addon, so I’m fine with trying to figure it out myself, but if you could point me in the right direction, it would be appreciated.
If not, no problem 🙂

[jasecorn]

Awesome! Thanks!

[Author]

Posts