• Resolved YaronRaz

    (@yaronraz)


    Hi,

    Is there a function that prevents entering data, if the main field already exists?

    For example:
    Field “ID”= 1
    Field “Name”= Alex

    If I use sds-form to enter a new entry in the field “ID”, and that entry already exists, I would like to receive an error message.

    Also, Is there a way to update an existing field, according to a different field, from the front end form?
    For example:
    Field “ID”= 1
    Field “Name”= Alex

    I would like to enter “ID”=1, and change “Alex” to “Alexa”?

    Thank you

    https://ww.wp.xz.cn/plugins/custom-searchable-data-entry-system/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author ghazale

    (@ghazale)

    Hi @yaronraz

    The ID is being created automatically when the entry is being inserted. And it’s the “Primary Key” that the whole system is working based on that.
    Since it’s being created automatically, the ID that you define is not the primary ID that the system knows, thus if you wish to do it that way, then you should manipulate the main file of the plugin.

    As for your second question, yes you can update any entry you wish. Just go to “Entries” submenu and click on the “Update” link that you see beside each entry.

    If you still have questions or concerns, you are always welcome to contact me anytime:)

    Cheers;
    Ghazale

    Thread Starter YaronRaz

    (@yaronraz)

    Hi,

    Thanks for the reply.

    Is there a way to update fields from the site itself, and not from the WP-Admin?
    If a user searches his information, and finds an error, can he correct it from the site itself, without an admin?

    Thank you

    Yaron

    Plugin Author ghazale

    (@ghazale)

    Hi Yaron,

    It is possible by modifying the code. However I really don’t encourage you to give users the ability to update the entries because of security reasons. It’s always a bad idea to give users direct access to the database information. It dramatically increases the risk of database attack and the danger of accessing sensitive information.

    If there’s anything else that I can help you with, feel free to contact me.

    Thread Starter YaronRaz

    (@yaronraz)

    Hi Ghazale,

    This was actually an example.

    In my case, I have a database for plants, that includes a log field.
    What I would like to do is scan a barcode on the plant lable, pull up the details and the log, and be able to edit the log directly from a site, such as adding information of changes done to the plant.

    This way, anybody working on the plants can update the log, without having to enter the WP-Admin.

    How would I be able to change the code to enable this?
    Keep in mind that I don’t have knowlesge in PHP, just basic HTML/CSS πŸ™

    Thank you

    Plugin Author ghazale

    (@ghazale)

    Alright for the first part (scanning the barcode and pulling up the details) is out of the scope of this plugin. Because it needs to talk with your barcode reader machine via a different approach.

    But for the second part (updating the log) I can make the “Update” and “Delete” links appear on the frontend at your own risk. If this is what you want, then let me know; so I can make a code for you to swap with the original one and achieve what you want.

    Thread Starter YaronRaz

    (@yaronraz)

    Hi Ghazale,
    The barcode reading part is avtually very eady.
    I connected a barcode scanner to my phone (with a OTG adaptor) or computer, and scan the barcode into the search field.
    Works great and pulls up the details according to the form.

    I would appreciate you making the “Update” button, so I can incorporate it into the site.

    Thank you very much

    Yaron

    Plugin Author ghazale

    (@ghazale)

    Hi Yaron,

    I’m glad you found your way for the first part. I’ll make the “Update” button work on front-end. I’ll send you the link of the customized version of the plugin within today or tomorrow.

    Please take into consideration that I’m putting my time and effort for customization, so I really appreciate if you consider a donation after you received your customized version:)

    Cheers;

    Plugin Author ghazale

    (@ghazale)

    @yaronraz

    Hey Yaron, please send me an email through my contact page. So I can send you further instructions about your customized plugin.

    Plugin Author ghazale

    (@ghazale)

    @yaronraz

    Hi Yaron,

    I’ve sent you a comprehensive email including some important notes. But I didn’t get back any response from you. Did you check your email? Maybe the email is gone in your spam folder. So check that as well.

    Update me.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Double entry in field’ is closed to new replies.