I have a field called "Child_of" that links the child with the parent, both located on the same table.Since Airtable does not offer backlinking to the same table, I need a formula to know if the parent has a child. I do not need the backlink to be ad...
I have a table with a field called "plact_is_main_activity"Only one record for all the records sharing the same "_plact_asset_" can be "plact_is_main_activity"=TRUESo I have set an automation triggered when "plact_is_main_activity" is updated.When tr...
I have three tables: PROJECTS, ASSETS and PLACEMENTSIn both ASSETS and PLACEMENTS there is a field that links to PROJECTS, with the possibility of linking to multiple projects. They are called asset_projects and placement_projects respectively.I need...
I have a table called 'accounts' and another one called 'users' linked to accounts in a one account to many users relationship. I want to create a field in the table users that shows an array with all the other users in that account except themselves...
I would really appreciate if someone could help me with the following script:
I have a table called VARIABLES with certain costs {variable_name} and the possibility to assign to a cost concept different groups of assets {variable_groups}
Then I have...
Thanks Shannon but it will not work because a lookup only tells me if the record has a parent not if the parent has a child. Same with Rollup and Count.See in the attached screenshot how I need the first record "Solar panel" to show that it has child...
Thanks Adam,I have finally solved it by creating another table than links one PROJECT to one PLACEMENT rather than having a link in ASSETS and one in PLACEMENTS, both to PROJECTS. You gave me the idea when you suggested to remove the link between ASS...
Thanks @TheTimeSavingCo for the help.The three tables are PROJECTS, ASSETS and PLACEMENTS.The same asset can be applied in several projects and a project can apply several assets, so the link between both tables is many to many.One asset can be distr...
Thanks @Justin_Barrett. :slightly_smiling_face: My main motivation is to identify someone with the skills to do it who I can contract every time I have a new need for a script. My second motivation is to learn scripting by analysing the code they w...
