Skip to main content

I need to automate duplicating records in Table B based on records in Table A maybe a script?


The idea is a school database, I need to pre-generate attendance records with a date and have teachers simply click on "Present’ or ‘Absent’ field.

Yeah script would work. Could also do this via an automation too I think, depending on how your table’s laid out


Thanks Adam, I’m interested in the script it’s pretty much duplicating some fields in Table A and keeping the status field empty in table B. Table A has linked fields which is making it a bit harder to figure out the script.


Thanks again


Reply