InfoPath Dev

I have done a unique row count many times in the past. When I say unique I mean that the repeating table will increment even when a row is deleted. I do this with a field I call max that increments onchange of my repeating table, then use this value to insert in to my row field and not reset this row field value. Now in 2013 I have a repeating ...

Hi Everyone,   So I have two tables in SQL that I am trying to test out on InfoPath 2013 before I start building more of the database. Table A EMP_ID, FirstName, MiddleName, LastName   Table B  Address_EMP_IDFK, Address, City, State_IDFK, ZIP   Address_EMP_IDFK (Named poorly at the moment but I know what ...

So I figured out how to make it not appear missing. It had to do with the way my tables were set up. I had an Address ID with Identity as the Primary Key.  Instead I changed it to EMP_IDFK without identity, and used it as a foreign key to the first table's primary key. This allows it to generate in the ...

Hey, Thanks for the reply.  When you say "Add a condition to your sum formula" what do you mean?  I will look at the unused column but im not the DB owner and will have to check with the developer if he is happy for that to happen to store the values. Thanks again

Thanks alot for support ! Suddenly found this problem and with your solution and a little more works this problem solved ! because of missing file error, in addition to above task, i extract .cab file and put .xsn file inside of extracted directory , and open it with design mode and save it to mysite.

Hi Kevin, I am suspecting that the items for field A are also queried therefore refreshing the value for field A when changes occur to field B. If so, then you might need to add another query data connection specifically for field B so that it won't interfere with the previous item. Please let me know if this approach works for you, if ...

Hi Ander2cc, I believe that there is a way to remove the time at the Designer. Could you try setting the current item type as a Date and not as a string? Please let me know helps. Regards, 

Hi Karen, I am attaching a simple form which shows how frequent an item has been selected. If you check on the calculated box's formula, it uses a sum formula which I then divided to itself so that each selection would only count as 1 and not the total sum. sum(Answer[. = "3"]) / 3 I'm not sure if this approach will work for ...

Hi Matthias, Sometimes values do not re-calculate itself and would need to add more logic and use a hidden field. Could you try adding a hidden field, with an action that sets another field's value (to any value you desire). Set this hidden field to the value of the people picker's account ID (assuming that the user can only select 1 ...