Auto Ranker Script Generator

Instructions

• 1. Create a new table and call it whatever you want (Let's call this the ”Rollup” table)
• 2. Create a linked field in the table that contains all the data that needs to be ranked (The ”Data” table)
• 3. In the ”Data” table, link all the records in this table to one record in the ”Rollup” table (i.e. select the field header, then paste a value, e.g. ”Rollup”, into it)
• 4. In the ”Data” table, create a ”Last modified time” field, select ”Specific fields”, and select all the fields that you're ranking by
• 5. In the ”Rollup” table, create a ”Rollup” field, select the ”Last modified time” field you created in step 4, and set the formula to ”Max(values)” Youtube video of steps 1-5
• 6. Set up the automation where the trigger is ”When field is updated”, and select the field from step 5. Set the action to be ”Run script”
• 7. Fill out the form below and click ”Generate”. The script will be generated automatically and you can then paste it into the script area from step 6. Remember to test it! Youtube video of steps 6-7
• 8. For convenience, we would also suggest setting up an automation that automatically links any newly created records in the ”Data” table to that one record in the ”Rollup” table Youtube video of step 7