Form upsert

[joshblevins]

I am trying to add multiple upserts to a form. However on the second upsert in the values section the Key elements will not display any of the elements where as the first upsert works fine.

Are you only able to use one upsert per form.

If so is there a to do this.

For every employee added

insert row into annual training table for multiple training's.

 

[cheesegrits]

This sounds familiar, I think it's an issue I was fighting with a while back. I'll take a look.

-- hugh

 

[cheesegrits]

I think this commit may fix it:

https://github.com/Fabrik/fabrik/commit/b1d13b812fc5a34cf822cce6f98ce7f874786e30

You really just need that one file. I don't usually condone cherry picking files from github, but as long as your code base is relatively recent (like 3.7 or greater), you should be able to just upload that one file.

-- hugh

 

[joshblevins]

I downloaded the one file, which I had the same problem adding multiple. So I did a complete update and continued having the same problem.

 

[troester]

I didn't test the functionality.
But with this commit I can add/save/edit a 2nd upsert plugin.

Did you clear browser cache after updating?

 

[joshblevins]

I did not looks like that is where my problem was I cleared cache and I could add a second upsert after I get them added I will let you know if it functions ok

 

[joshblevins]

Ok I just tried to setup it looks like I can add a second upsert as long as it is not to the same table as any other upsert.

What I am needing to do is this.

When I add a employee if they are X type of employee I need to add a row to my competency table for each competency the employee needs to complete.

 

[cheesegrits]

Ok I just tried to setup it looks like I can add a second upsert as long as it is not to the same table as any other upsert.

What are the symptoms? You mean the settings don't save properly, or the upserts don't work if you have more than one to the same table?

-- hugh

 

[joshblevins]

When trying to add the next upset the drop down for elements where the values go will not populate a list if you are choosing a table u already have an upsetting on

 

[cheesegrits]

Interesting. I'll take a look at that when I get a few minutes.

-- hugh

 

[joshblevins]

I am thinking of a new solution instead of doing a upsert on each new add of an employee. I think this will be better served as a daily cron job.... I am working on the queries I need to complete this now.