If 3 fields match lookup then add Timestamp to sharepoint list - InfoPath Dev
in

InfoPath Dev

If 3 fields match lookup then add Timestamp to sharepoint list

Last post 07-23-2018 10:29 AM by Hilary Stoupa. 8 replies.
Page 1 of 1 (9 items)
Sort Posts: Previous Next
  • 07-20-2018 02:34 PM

    If 3 fields match lookup then add Timestamp to sharepoint list

    I have a form called "TimeStamp Form" that will look into my sharepoint to verify the information and if it is equal then when I press the button I want it to update the field in the Sharepoint list in the field TimeStamp. I would like it for the timestamp to be the "Username" & "Now". Any help would be greatly appreciated. This is my first time using infopath or sharepoint so not very knowledgeable, however a wiz when it comes to excel! I have upload my form for any help you can provide!
    Ray
  • 07-20-2018 02:56 PM In reply to

    Re: If 3 fields match lookup then add Timestamp to sharepoint list

    So - you'd be updating an item in a different list? Or the same list as this form uses?
    Hilary Stoupa

  • 07-20-2018 03:01 PM In reply to

    Re: If 3 fields match lookup then add Timestamp to sharepoint list

    In the same list
    Ray
  • 07-23-2018 06:09 AM In reply to

    Re: If 3 fields match lookup then add Timestamp to sharepoint list

    Sorry for my ignorance - 1st time working with infopath!
    Ray
  • 07-23-2018 07:57 AM In reply to

    Re: If 3 fields match lookup then add Timestamp to sharepoint list

    Ok. So if it is in the same list, you can add another data connection to query the list. You could probably set the query to not run when the form opens (this is a checkbox toward the end of the dialogs when you set up the data connection) and then set the query field to the value you wish to look for on your button click, followed by a rule to run the query. After that rule, you could add another rule with a condition that the number of items in the returned data fields (for this same data connection) are equal to zero, set the field you wish to update.... Hope that makes sense?
    Hilary Stoupa

  • 07-23-2018 09:48 AM In reply to

    Re: If 3 fields match lookup then add Timestamp to sharepoint list

    Would that be the same as using a rule on submit & use the "run query" then "submit data"?
    Ray
  • 07-23-2018 10:09 AM In reply to

    Re: If 3 fields match lookup then add Timestamp to sharepoint list

    Not really - I am trying to understand what you are wanting to achieve. If you just want to update any field for the list item you are currently editing, you can add a rule to do that prior to submitting - just add a rule to set the field's value. If you are actually needing to check all the other list items first for the same value and if none match, update the field in this item instead, you'd need to query the entire list.
    Hilary Stoupa

  • 07-23-2018 10:11 AM In reply to

    Re: If 3 fields match lookup then add Timestamp to sharepoint list

    This form would be for our locations to select their location - the customer number & the container number - when they hit submit button, I want it to find that record in the sharepoint site & update the field "TimeStamp" to show Username & Time & Date that the button was pressed.
    Ray
  • 07-23-2018 10:29 AM In reply to

    Re: If 3 fields match lookup then add Timestamp to sharepoint list

    I don't see a field named "Timestamp" in the data source for the form you provided - if the row is in a different list than the list this form has been used to customize, you'll need to use SharePoint Designer Workflow or MS Flow to update the other list. If it is the same list, I'd guess you need to first query for the list item you want (from within the form) and you could change your submit to use rules so that you could set the field prior to submitting. :-) Sorry I'm having so much trouble understanding.
    Hilary Stoupa

Page 1 of 1 (9 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.