matt_stewart - profile

matt_stewart · Sep 17, 2020

I understand two-way sync won’t work currently, maybe never. But is there a way that I can re-link data? For example… Base A is a Product Catalog for Sales, and shares project data to Base B Base B is a Product Catalog for Designers, and shares produ...

Security - Sharing or User Permissions? · Sep 17, 2020

I’m having trouble with setting up better security here for critical/confidential data. I setup Tables with permissions for only myself to add/delete records. I setup every Field with permissions for only specific people to update data in the fields ...

matt_stewart · Jul 31, 2020

I have a script I run that manages task due dates. Using self linked table to setup predecessor tasks with manual start date and manual lead time fields, it calculates the end due date. The script pulls the predecessors end date and checks if the tas...

matt_stewart · Jun 11, 2020

I have 2 different lookup fields: Release1 = lookup individual item release date from another tableReleaseMulti = rollup multiple items release date based on condition (if its a multi-item) using MIN(Values) I then have a formula field: RELEASE = IF(...

matt_stewart · May 22, 2020

I have a table of subtasks called subtasks. this is the todo list for the whole team. I used self-linking to get predecessors setup, and so I have: a rollup field showing the predecessor end date (PredEnd)a manual task start date (START)a manual task...

matt_stewart · Oct 23, 2020

how are you getting the linked field to populate? im not seeing a way to do this in the automation, or do I need it to run a script on any blank ones and write the code for?

matt_stewart · Jul 31, 2020

this looks like exactly what I need, thanks! ill review and work it through, and followup as solved or questions afterwards. thanks so much!

matt_stewart · Jul 31, 2020

Integromat is yet another paid service, so id like to avoid that. Its one of my qualms with Airtable that so many things rely on these paid 3rd party services as opposed to enhancing the internal paid features of my pro or enterprise plan. Automation...

matt_stewart · Jun 11, 2020

never mind, im an idiot I was pulling the wrong linked data since I have to link 2 different ways to get the single items vs the multi items from the other table the change for Release1 to a Rollup using MIN(values) does in fact solve the problem. Th...

matt_stewart · Jun 11, 2020

I did not know lookup returns an array… are you sure of that? The Release1 lookup is pulling a manual date field from another table. The ReleaseMulti rollup is pulling an array of those manual dates, but then giving me the “Min(Value)”. I have tried ...

User Statistics

User Activity

Re-Linking data or two way sync?

Security - Sharing or User Permissions?

How to pause script and then repeat automatically?

Grouping By Date not working

Scripting Block formula help on comparing two dates

Re: Re-Linking data or two way sync?

Re: How to pause script and then repeat automatically?

Re: How to pause script and then repeat automatically?

Re: Grouping By Date not working

Re: Grouping By Date not working