I am using ArrayUnique(values) as in a rollup field and then referencing this in a make.com scenario to output to a Word document. This works, but the output is a bit unfriendly.Products Acer_Vero B7_B227Q,Acer_Vero B7_B277,Acer_Vero B7_B247Y I have...
I have a simple linked table. There is a table of CASES with a bunch of fields and then another table called CASE ACTIVITY which has scheduled activities for each CASE, so the tables are linked by CASEID which is the primary field on CASES.That all w...
I have a table that includes a single line text field called 'Product Import' and a linked record called 'Product'. I use the CSV import extension to pull in a CSV in to this table and display the result on the Data view.When the import completes, th...
I'm having difficulties understanding how to link these two tables and would appreciate a little help.Table 1 called "Products" looks a bit like this:MakeLineModelTypeDellLatitude123LaptopDellOptiplex3231DesktopHPProbookA34LaptopAll the fields are Si...
Let me start by saying that I have been trying to do this in Interfaces but I've also had a look at the new Forms feature.What I would really like to do is present the user with a grid with 4 columns: MakeLineModel Qty When the user clicks in the ...
It looks like it's a make.com problem rather than an Airtable problem - I have now confirmed that the Word Template module in Make does not pass on the newline characters - the input to the module is formatted correctly. I am now experimenting with G...
Thanks but my output in Airtable doesn't look like that. The items are all on the same row, though I have the formula the same as yours.ARRAYJOIN(ARRAYUNIQUE(values),'\n') EDIT: but it looks ok in expanded viewEDIT EDIT: but it does look like yours i...
Yes I do and I will need to handle overdue activities but I wanted to play with a timeline view that showed what was due to happen this week. It may be that it's not a linear path, so there are activities that are overdue but others are scheduled and...
ok - slight final glitch. I wanted to add the 'Next date' field to a timeline view, but Timeline only allows you to add a 'Date' field to the view and this is a formula field.
