I feel like I am close... Just missing something I can't put my finger on.
I have created a data table, the columns are used in a form to Generate a File.
I have a column in another data table which call the file location.
But I cannot get the file to populate in the record.
Driving Cost Compare Data Table
The Form works perfect. Generates the File named:
CONCATENATE("https://drive.google.com/drive/folders/costcomparison", [Traveler],[Row ID])
Request Table
I have another column in another data table (Request Table) which I want the file to be added to when the user creates the request. The file is generated prior to creating the request.
But I don't think I am using the right formula expression.
CONCATENATE("https://drive.google.com/drive/folders/costcomparison", Driving Cost Compare[Traveler],[Row ID]) (Driving Cost Compare is the Data table used to initially create the file.)
User | Count |
---|---|
25 | |
14 | |
4 | |
3 | |
3 |