The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have three tables, States, Cities, Streets. A street is linked to only one city, and a city is linked to only one state. Of course, a state has multiple cities, and a city has multiple streets. How do I get a view/interface to show every unique ...
I have three tables in one base. In each table, there is a Name field and a checkbox field named “Flag”.
How do I create one “grid” (or interface or anything else) that lists only the record names from all three tables that have the Flag checkbox ch...
Is there a way to export the structure of a table to csv, JSON, etc.? Specifically, I’m looking for a way to export information about a table, not the data itself. Some method that will give me an output like field 2 is long text, field 3 is lookup...
I have a table of activities with start and end date columns and a column for the person assigned to the activity. There will be hundreds of activities but only one person should be assigned to each activity. How can I see if a person is assigned t...
I had a similar problem. Three tables each with their own interfaces in one base. I could open the details on two of the interfaces, but not the third. Adding another grid and deleting the old one fixed the problem for me.
Hello Theirry,
I don’t know if you ever resolved this or if AT updated behind the scenes, but this formula is what works for me in both lookup and linked fields:
SUBSTITUTE(ARRAYJOIN({Linked_or_Lookup_Field)}),", ","\n")
Trying to put the “\n” inside...
Thank you, Ridha! I was looking “top-down” instead of “bottom-up” – the Streets table does show the unique data row by row, though the columns aren’t in the order I’m looking for (State-City-Street). I can fix that with an additional column with a ...
Thank you very much for your ideas and the detailed explanations. The “Table with automation” sounded like the most difficult to manage on an ongoing basis, especially with the data going into different columns. I tried both the synced base and you...