by Variance InfoTech Pvt Ltd

Need to auto populate value based on the value of related field? For this requirement Auto Populate is the perfect solution. The advanced configuration tools allow you to clearly define what should happen whenever a related field value changes.

Free 30 day trial
Try it Now

#2049 - Add-On Does Not Display Custom Fields That Are Checkboxes

Closed Bug? created by kinetix 4 years ago

I just downloaded the add-on and when I go to select fields from my primary and secondary modules, I don't see my custom fields that are checkboxes. I do see other custom fields I created.

Versions: SuiteCRM 7.10.7 PHP 7.2 SQL Server 2014 Windows Server 2012 R2

  1. kinetix member avatar

    kinetix

    4 years ago

    Add-on also doesn't see custom fields that are dropdown fields either.

    • kinetix member avatar

      kinetix

      4 years ago

      I noticed that the newest version I downloaded has an additional feature (calculated fields) that forces you to add calculations to fields you want to autopopulate, which I don't need when populating fields. I tried to uninstall the module and it won't even uninstall. I have to overwrite my suitecrm instance with a backup and start over. It would be great if there was information listed on each of your releases and what functionality/fixes are addressed in each one. I am trying an older version of the add-on now.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Hello,

      We'll remove the mandatory option for calculation field and it'll be available from next release. We've also mentioned all the information in each release what functionality/fixes are addressed in each one.

      Release Note URL : https://store.suitecrm.com/docs/auto-populate-fields/release-notes

  2. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    4 years ago

    Hello,

    Currently our plugin supports only String type and Related Type field. For other type of fields like dropdown, checkbox, etc are under development. We'll update new release in next week which supports all kind of fields.

    Regards, Variance Infotech PVT LTD

    • kinetix member avatar

      kinetix

      4 years ago

      Ok, great. So next week you will have support for dropdown and checkbox fields or all types of fields available in SuiteCRM? When next week to you project to have the new release? Also, when I was going through the steps to create an auto populate record, I was forced to go to the calculated fields option and could not save the record unless I add calculations to to the field I wanted to auto populate. I don't want to have to add calculations and that seems to be a bug in the add-on. Can you address that issue?

    • kinetix member avatar

      kinetix

      4 years ago

      I also have auto incrementing id fields in my SuiteCRM instance. Will those also be available in the next release?

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Hello,

      We'll update our new release on next week Thursday. Also we'll remove the mandatory of calculation fields steps configuration.

      Regards, Variance Infotech PVT LTD.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Hello,

      We've consider fields in Field Mapping step which are display in Edit View and Detail View. So your auto incrementing fields Job Id and Customer Id display in Editview or Detail View?

      Regards, Variance Infotech PVT LTD

    • kinetix member avatar

      kinetix

      4 years ago

      The auto incrementing fields (Job ID and Customer ID) that I can't access in your add-on appear in both edit and detail views.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Hi

      Is it possible to be available or provide us teamviewer access to see it ?

  3. kinetix member avatar

    kinetix

    4 years ago

    I also noticed that after installing the add-on and then access through admin panel, I have to click on validate license every time to get access to create/edit records.

    • kinetix member avatar

      kinetix

      4 years ago

      And I after creating an auto populate record and saving it, it never appears in the Autopopulated Fields listview of created records. After uninstalling the newest version of the add-on, I decided to download the oldest one (1.0 versision 7.0). That is the version that is not saving the newly created records.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Ok. We've checked on our server and we didn't faced this kind of issue.

      is it possible to give us your CRM Details, Server access(FTP Details), Database Access if you don't mine?

      If yes then share your credentials on "info@varianceinfotech.com".

      If you provide us credentials then it'll be easy for us to understand your problem and you'll get quick solution.

      Regards, Variance Infotech PVT LTD

    • kinetix member avatar

      kinetix

      4 years ago

      I wouldn't be able to give you direct access into our dev environment but we could set up a screen share session. I also am unable to uninstall any version after installing it. It appears that the table(s) aren't created in the database after installing. Installation always completes at 100% and I perform a quick repair. So naturally when I try to uninstall the add-on it fails because it can't drop the tables. I did a search in my code and there many references to vi_autopopulate. I believe the table(s) just aren't being created in the database on install, which would be why creating a record in the admin panel would not save and display there. When would you be available to do a screen share? Thank you.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Ok.

      I think your database server is MSSQL 2014. Am i right?

      If yes then we need to change all database related queries to MYSQL because our plugin support MYSQL database Server.

      Regards, Variance Infotech PVT LTD

    • kinetix member avatar

      kinetix

      4 years ago

      It is SQL Server 2014. So, you're saying your plugin only works with MYSQL?

    • kinetix member avatar

      kinetix

      4 years ago

      I didn't see anywhere in your site or documentation about this limitation.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Currently our plugin supports only MYSQL. If you want to support our plugin with MSSQL then we'll ready to change in our plugin to your CRM by screen share.

      Regards, Variance Infotech PVT LTD

    • kinetix member avatar

      kinetix

      4 years ago

      Yeah, I'm not changing my database structure. Wish you would have this listed under requirements or compatibility or something so I wouldn't have wasted my time on this.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Ok Sure. We'll update.

      Shall we connect remotely and change all database regarding queries to MSSQL? So you'll able to use our plugin.

      If yes then please tell us your feasible time for connect.

      Regards, Variance Infotech PVT LTD

    • kinetix member avatar

      kinetix

      4 years ago

      Seems that the add-on should not complete installation at 100% if the tables don't install. There should be some type of check in the install to look for required database type, then quit installation and alert user of the issue. Hope that feedback helps you to help other users in the future.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Thanks for your feedback.

      We'll add this things in our plugins.

      Regards, Variance Infotech PVT LTD

    • kinetix member avatar

      kinetix

      4 years ago

      You're welcome. It would be great if you would add in support for SQL Server too. If that happens, I would use your add-on.

  4. kinetix member avatar

    kinetix

    4 years ago

    Hi, Are you still on track for releasing the update tomorrow? Will this include support for SQL Server?

    Thank you.

  5. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    4 years ago

    Hello,

    We're releasing new update on Friday. Currently We're working on MSSQL Support.

    Regards, Variance Infotech PVT LTD

    • kinetix member avatar

      kinetix

      4 years ago

      I thought MYSQL support was already provided in this add-on. I received an email last week from Rahul Patel, who said that SQL Server support was being added in the next release.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Yes. Currently our plugin support on MYSQL Database. We've some of the customers who has used MSSQL for SuiteCRM. So for that we're updating our to support MSSQL and MYSQL both.

      Regards, Variance Infotech PVT LTD

  6. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    4 years ago

    Hello,

    Please confirm your availability tomorrow to review your issue.

    As per our earlier discussion you're looking to sync JobID which is Auto Increment field.

    • kinetix member avatar

      kinetix

      4 years ago

      Hi. Correct. I'm available tomorrow between 8am-10am or 11am-5pm EST. Thank you.

    • varianceinfotech member avatar

      Variance InfoTech Pvt Ltd Provider

      4 years ago

      Hi

      Are you available on Chat ?

    • kinetix member avatar

      kinetix

      4 years ago

      Yes, for about 30 minutes. What chat program do you use?

  7. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    4 years ago

    Sent you Invitation from Slack

    Please Accept it.

    Please confirm you've received.

  8. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    4 years ago

    Hello,

    Please let us know if you have any more questions on this ticket. If not then we will close this ticket.

    Regards, Variance Infotech PVT LTD

  9. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    4 years ago

    Hello

    Thanks for your valuable support and being our customer. As per our last discussion related to ticket, hope you've received satisfied answer from our support team. For now, We're closing the ticket but if you've any questions or concern feel free to email us on techsupport@varianceinfotech.com or reply to the same ticket.

    Regards, Support Team Variance InfoTech Pvt Ltd www.varianceinfotech.com

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...