locked
InfoPath Auto-Generating TextField Showing NAN RRS feed

  • Question

  • Hello there,

    I have SharePoint custom list, that I am trying to designee with InfoPath. One of the issue I am currently facing is Auto-Generating textbox.

    I have followed the following steps and I Keep getting Nan.

    • Create a custom list, named "Auto".
    • Create a column in that list, type number, named "Auto No.".
    • Clicked List -> Customize Form and edit default form in InfoPath.
    • Clicked Data -> Data Connections -> Add in InfoPath.
    • In "Data Connection Wizard", set New Connection to Receive Data -> SharePoint library or list -> set URL of my "Auto" list -> only select ID column  -> checked "Automatically retrieve data when form is opened"
    • In InfoPath design view, right click "Auto No." text box -> Properties -> Default Value -> fX button -> Insert Function -> Math -> Max -> OK -> double clicke on the formula to select field -> Show advanced view -> in "Fields" drop-down choose secondary data source (named as my "Auto" list) -> selecte 'ID' node in 'dataFields' -> OK -> back in formula type '+ 100' (so the whole formula is like: 'max(ID) + 100')

    What I am doing wrong?

    Thanks


    Abenet


    • Edited by NewET12345 Tuesday, August 15, 2017 1:24 PM
    Tuesday, August 15, 2017 1:12 PM

Answers