This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I'm curious how others address this challenge. In our project management base we have a combination of tasks and meetings. Tasks do not really need times, only start and/or due dates. Meetings, on the other hand, need both dates and times. Our curren...
In my template table I have a lookup field that is formatted as currency. In the child table I have the same field with the same formatting, but I'm getting an "root must be a number" error when I run the script. I'm guessing this needs to be modifie...
I have a script that I am testing on a CRM system we use and I’ve run into an issue. The basic automation workflow looks like this:
A new record is added to a form which shows up in a view called “unprocessed.” This view is filtered on a linked recor...
I’m trying to compare two fields. One contains certification requirements for a role and the other the certifications achieved by an individual. The certification requirements are contained in a lookup field. The certification achievements are contai...
We’re still in the testing phase with airtable so we’re new to the tool.
Question: how can you/do you filter (or search) on a number field? I’d like to filter for greater than or less than, or for numbers within a range, but the only filter options I...
You could use a separate Status table to track status changes rather than what is most often used - a single select status option within the same table as the projects themselves. In a Status table, which would be connected to your Projects table wit...
The idea of adjusting editor habits is helpful. Sometimes one can get hung up in how things are "supposed" to be - so just changing a mindset opens up new opportunity. For us that would mean tasks should have a beginning of day time (e.g., 8am) tied ...
That was it. Thank you! I'm not skilled in JS - so I truly appreciate the assistance, and the added "fun facts." I'll also review the link you sent. Learning something new is never a bad thing.
This may help better explain my question ... This the excerpt from script where the value from the template. The lines in question are in bold. The Rate field in the template is a lookup with the result formatted as currency. The Rate field in the ch...
