I’m going to be be copy and pasting items from excel to the SharePoint list, but I’m using Quick edit. I’m doing it this way becuase I want to create a lot of items at once. It does bypass the logic for the forms but its okay since I’m doing I can make it match all the logic and rules. (I would never let my users do this) the only thing I can’t figure out it how to fill in the _vLookupID or the _DFFSID using this method I’d like to just have an excel formuala that adds 1 to the count and just copy and paste it in there with the rest of the data.
I guess I’m asking how does DFFS pick those IDs? Is there an excel formula I could use to create them?