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...
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 ...
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...
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(...
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...
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?
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...
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...
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 ...
