InfoPath Dev

You are a star!!!!!

See attached. Save the file locally, right click and select design. Then preview. There is one table with a bunch of years filled out and the same table below with conditional formatting rules on it.

Hello Hilary I choice a different method. I create 10 different forms. and each forms use their ID for invoice number. for example: for my first product invoice number is ID+122 , for my second product ID+35 etc. its not simple and good way. I know its very hard way but i have to :(

That right. How do i make conditional formatting rule? if you can guide me to step by step? like formula something?

Got it - you want to set a filter on the repeating table to only display items where the year is between those values. So - add a conditional formatting rule to your repeating table with the condition that the Year column is greater than or equal to 2016 AND that the Year column is less than or equal to 2019. :-)

Hi Hilary, sorry for not making it clear. Ok here the repeating table for example when I run like eg See image link https://i.ibb.co/dB6GsJg/wefwef.png I hope it clear?

Do you mean that the value in the column should look like "2016-2019" or that the value should be anything from 2016 up to and including 2019? Or something else that I'm not understanding? :-)

Hi, I'm looking for a way to display repeating table with Year on column that must show range of year for 2016-2019. I tried use formulas as it look like only accept return one value, can it possible to show more than year value?

Hi, I've been trying to develop it for past few days. So when the repeating table populated as often it return large number of row. as I want limit to 4 rows. minimum and ease for user to interact. I've tried google and find a way. No luck

Hi - what do you mean department is showing as ID? Do you mean in the dropdown itself? Is the Department a lookup in your Job Title list?