Re: Concatenation using an active directory (id) field, current user and autonumbering

Skarn — Wed, 01 Jun 2011 12:52:37 GMT

Date fields in Infopath forms store their text as YYYY-MM-DD so you can use substring function to strip the first 4 characters.

As for the incrementing id to represent the count of previous appeals, unless you have a way of retrieving previous tally submissions made via the form (maybe via a secondary data connect? are you using SQL server?) the form has no way of knowing this figure and can't increment it accordingly.

If all the appeals are stored via the form and every appeal is appended to a pre-existing form with the appeal data in it (ie you have a repeating group structure) then you could use the count function on the group each time a new repeating section is added.

Concatenation using an active directory (id) field, current user and autonumbering

dinakaye — Wed, 25 May 2011 17:13:10 GMT

I need help creating a unique concatenated ID field for a grievance application. HR policy only allows an employee 2 appeals in a year, but they still want to capture all applications submitted. I want to keep track of the number of appeals each employee submits in a given year over the lifetime of the employees employment.

My desired concatenation to use as the form ID would be employeeID-YEAR-##

concat(TXTempCDSID,"-", TXTappDATE,"-", strFilename)

How can pull theyear [YYYY] from the TXTappDATE field and then autonumber with a whole number?

Every employee has a unique employeeID, the appeal application ID field should show HR the exact number of grievances (eligible or not) an employee submits whether they are eligible or not.

General

Re: Concatenation using an active directory (id) field, current user and autonumbering

Concatenation using an active directory (id) field, current user and autonumbering