The new configurable “Record Detail” Interface is a fantastic and long awaited feature in my book.However, its functionality is severely limited by the fact that all Pages within an Interface share the same “Record Detail” Interface for a given table...
Hello, the airtable documentation shows that to sort a query using selectRecordsAsync you should do it as follows:
let queryResult = await table.selectRecordsAsync({
sorts: [
// sort by "Description" in ascending order
{field: "Desc...
Right now I have a multiple select field as follows:
The script I’m trying to run has already identified the record IDs of all records with “Split Invoice” as a status.
What I’m trying to do now is to remove that split invoice status and leave the r...
This is fairly simple to do if the values in each column are separated by a character, like a comma or space.It is much more difficult if you want to compare every possible selection of characters from a string in one column, to every possible select...
Yes, but only by copying the Interface that already has the details page set up the way you want.Then you can alter the copied interface to become whatever you wanted the new one to be.There is no way to copy the details page layout to another, alrea...
As far as I am aware, the only way to create a two-way link within the same table is to use automations.1. Create a new automation2. Set the trigger to "When a record is updated"3. Set the table to the table with people in it.4. Set it to watch only ...
This formula should work."+1 " & SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Phone #}, '(', ''), ')', '')," ","-")It finds and removes the parentheses with the SUBSTITUTE function, then finds the remaining " " (Space) and replaces it with "-". Then you just us...
I think your intuition is correct:The only way I can mentally come up with a model that would work is if I had a table "Owners" and linked the Deals to an Owner. Then I should be able to use a record picker to select the Owner from the Owners table a...