-
You need to just requery the data connection where you are getting the new ID from. So - I am not sure which data connections you are requerying, but it needs to be the one to the library you just submitted to. Drag the data fields onto your form so you can see if the new item that you just submitted is there.
-
Would i do that by added another rule? I added two to refresh different connections and it seems i am getting the same results.
Had a thought, would it be easier to create a unique identifier another way, store that in the form and use that as the ID in my email?
-
You need to requery the data connection. If your data connection to get the library items runs on load, the data you just submitted won't be in it - you need to query the library again after submitting to get back the just-submitted item.
-
That's what I thought, but it hides everything. which in turn causes the sum to not work properly (i think?). just to confirm, the preceding-sibling rule goes on the repeating table and the sum formula would be used 4 times, one for each quarter? what about category in the repeating table? I was just using d:category, but does that need a ...
-
its part of the rules when the submit button is clicked.
-
When do you query for the data?
-
not sure how helpful this is, but i took some screenshots of the rules im using. When i run the attached rule its blank. If i take off the filter i just get the first ID number in the list.
-
unfortunately i got a slap on the wrist when i did that last time. Wish i could.
-
Feel free to attach a copy of your form under the options tab in a reply if you'd like me to take a look. :)
-
Yeah it is interesting. I tried two things after the form submits
1. First submit to SP, then send email pulling the "ID" field from the SP into the email subject but its either blank or only pulls in the first ID number listed (not tied to the specific form)
2. set a rule to run after form is submitted to fill in a field on the ...