Auto Create Record
Can I auto create a record on every specific date of the month using a script.
#Creates one record for each day of the current monthSet Variable [ $Today ; Value: Get ( CurrentDate ) ]Set Variable [$Date ; value: $Today - Day ( $Today ) + 1 //computes date of first day of this month ]Loop Exit Loop If [$Date > Date ( Month ( $Today ) + 1 ; 0 ; Year ( $Today ) //computes date of last day of this month ] New Record/Request Set Field [YourTable::DateField ; $Date ] Set variable [$Date ; value: $Date + 1 ]End Loop
A variation of this can replace $Today with a global date field and then the script can generate these records for any month/year selected by the user when they select or enter any date from that month/year.
Thanks alot Phil and sorry for replying late,
1. I didn't get where I will add the script
2. How can I fix it to create a new record on 15th of every month.
Hello any update on this please
Retrieving data ...