Use Lookup to Autofill files

Certainly! To autofill a file selection field based on a lookup field in PHPRunner, you can follow these general steps:

Steps to Autofill File Selection Field

1. Create Your Lookup Field: Ensure you have a lookup field set up in your form. This field can be used to select a category or any identifier that correlates with the files you want to display.

   
   

2. Add a File Selection Field: Make sure you have a file selection field in your form where the user will be able to choose files.

   
   

3. JavaScript for Autofilling:

   • You will need to write some custom JavaScript to handle the change event of the lookup field. This JavaScript will fetch the relevant file names associated with the selection and populate the file selection field.
   
   
   
   

4. Refreshing the File Selection Control:

   • After populating the file selection field, you can call a refresh function on the file selection control to update its display.
   
   
   
   

Example JavaScript Code

Here is a simplified example of how you might implement this in the OnChange event of your lookup field.

// Assuming 'lookupField' is your lookup field ID and 'fileSelectionField' is your file selection field ID

$("#lookupField").change(function() {
 var selectedValue = $(this).val(); // Get the selected value from the lookup field

 // Fetch the file names based on the selected value
 $.ajax({
 url: "path_to_your_script_to_get_files.php", // A script that returns file names based on the selected value
 type: "GET",
 data: { value: selectedValue },
 success: function(data) {
 var files = JSON.parse(data); // Assuming the response is a JSON array of file names

 // Clear the file selection field
 $("#fileSelectionField").val('');

 // Populate the file selection field with the fetched file names
 // You might need to format this based on how your file selection field expects input
 $("#fileSelectionField").val(files.join(','));

 // Refresh the file selection control (if needed)
 // Call a refresh method here if required, depending on your setup
 }
 });
});
PHP Script to Fetch Files
You’ll need a PHP script (path_to_your_script_to_get_files.php) that fetches the file names based on the selected value from the lookup field. Here’s a simple example:
<?php
if (isset($_GET['value'])) {
 $value = $_GET['value'];

 // Query your database or file system to get the relevant files
 // For example:
 // $files = getFilesBasedOnValue($value);

 // Sample response
 $files = ['file1.txt', 'file2.txt', 'file3.txt'];

 // Return file names as JSON
 echo json_encode($files);
}
?>
Notes:
Ensure to replace #lookupField and #fileSelectionField with the actual IDs of your fields.
The PHP script should be tailored to fetch file names based on your specific logic or database structure.
Make sure you have error handling in place for both the JavaScript and PHP code.
Test thoroughly to ensure that the autofill functionality works as expected and that users can still change files afterward.

This approach should allow you to autofill the file selection field based on the lookup field while still giving users the flexibility to modify their selections.