We have an app where different vendors will upload their workers to a table.
We give each vendor the same generic spreadsheet/template - purposely leaving out the "Vendor Name" field as it will be different for every vendor, and we also don't want every vendor knowing the other vendors etc.
When the vendor does the bulk upload of all their staff, we want each of the staff to have their field "Vendor Name" populated with whatever the user role of the person uploading is in.
This way, Vendor A uploads all staff into the table and all staff have their "Vendor Name" populated with "Vendor A" which is the name of the user role. Then Vendor B uploads all their staff and their "Vendor Name" is populated with "Vendor B", and so on.
Is this possible?
I have dynamic rules set on my main form to change the "Vendor Name" field "When the user - is in the role - Vendor A" -> "change - Vendor Name - A".
That's all good for adding individual workers but has no bearing on doing a bulk upload, it would seem.