Andrew_Heine - profile

Andrew_Heine · May 04, 2021

I am pulling the records from a table, and I am able to loop through all the records, but in the API documentation I can only see examples for pulling specific cell values by directly calling each specific field name. In order to future-proof the scr...

Andrew_Heine · May 10, 2021

This solution only works if you want to display in a single timezone for all viewers. I have collaborators across the world and I need it to dynamically display the date/time in each of their respective timezones. Any ideas how to do this?

Andrew_Heine · May 04, 2021

Ok still not working. ‘field.name’ doesn’t return the name as a string and getCellValue() requires the field name string as an input. I can’t for the life of me figure out how to get the string version of the field name here. It will spit out in cons...

Andrew_Heine · May 04, 2021

Here’s what I have. You have to go into the code to update the name of the table you want to add records to (line 37), dates/times of the time slots (which are in arrays starting at line 39 where the ‘deepDiveDays’ array uses days of the week in numb...

Andrew_Heine · May 04, 2021

You loop through the fields at the Table level, not the Record level: for (let field of inputEventsTable.fields) { console.log(`${field.name}`); } Of course I figured it out 10 minutes after posting here lol

Andrew_Heine · May 04, 2021

I made a script that can do this. This is my first time on a forum like this. What’s the best practice for sharing code? The script in it’s current state requires entering the date/time slots manually in the code itself, but I’m currently working on ...

User Statistics

User Activity

Programmatically loop through all fields in a record

Re: Choosing the time zone used for Date and Time functions

Re: Programmatically loop through all fields in a record

Re: Create Recurring Dates/Records with a Script or Automation

Re: Programmatically loop through all fields in a record

Re: Create Recurring Dates/Records with a Script or Automation