-
Okay, I modified the default formula to handle for the fail -> pass scenario.
(((A >= passing) * courseCredits) / 2) + (((B >= passing) * courseCredits) / (2 - ((A < passing) and (B >= passing))))
See attached template, I'll post a screenshot with the data as well.
-
Well, I'd try the query in Access first - My thought is that if you are actually copying a new DB file onto a machine, the create date may be the correct one. Not sure though.
But then, you should be able to create a data connection in IP to Access, and select any table, and click the Edit SQL button, and replace with this.
-
There is a DateCreate in the MSysObjects table - the entire DB file is being replaced / updated on a certain basis, do I remember your other questions correctly?
So, if the whole DB is being replaced, I wonder if something like this:
SELECT distinct CDate(Int(DateCreate)) AS CreateDate
FROM MSysObjects
Would work? I'm converting to Int then ...
-
Ah, I see - I misunderstood the scenario where they fail first semester but pass the second. I'll see what I can come up with.
-
In the sample form, if I fill it out with your sample data from your original post, it appears to exactly meet your requirements. Can you tell me how the formula is not working for your other scenarios?
-
Oh, I should add - just check the processing instructions in the XML that you sent via email - where is the XML expecting to find the template?
-
You can get the attachment name prior to that - use the GetAttachmentAttribute command.
-
Hey - sorry no one was able to help you before you figured this out yourself, but thanks so much for posting the results here.
-
Okay, so now in your form, drag the secondary data source data fields onto your form and preview it - I'd like to see a screenshot of the data with the extra comma.....
-
Hi - is Attachment2 repeating? I'm also confused by the use of the qRulesFilename attribute for the name fo the attachment - won't that be blank until after qRules submits the file and returns the filename?