Hi,
I am basically wanting to pre-populate all the data from the SharePoint list into the repeating table in the form, this data will then need to be filtered based on the username of the user accessing the form at the time. I do not have programming knowledge so I'm trying to find a codeless way of doing this. Hopefully this makes sense. Cheers in advance.
I currently have a custom list created with the following data:
Title | Username | Customer | Start Date | End Date
ABC | username1 | Customer1 | 20/4/2013 | 22/4/2013
DEF | username2 | Customer 2 | 18/4/2013 | 30/42013
In my form I'm wanting the repeating table to display all the information in rows as per above, sort of like a transaction history of the data. I have the above list feeding into the form as a secondary datasource and have tried the following on the repeating table but it will only show the first row of data rather than the complete list of information.
Repeating Table field example: Title:- Title[Username = translate(userName(), "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")]