Skip to main content

Solved

7495 Topics
M
Marc_SteinlinNew Participant
asked in Other Questions
F
F_terstalNew Participant
asked in Development & APIs
API update records doesn't work in postman.. created records does work and get records work to

HI, I read the document : https://airtable.com/appEYx9XUfEttr3Nr/api/docs#curl/table:table%201:update I just copy and past the code… and i get errors… but getting records or creating records it is working… I put the api_key as a parameter and in headers both doesn’t work for updating the records… In the header is put Content-Type: application/json https://api.airtable.com/v0/appEYx9XUfEttr3Nr/Table%201 { "records": [ { "id": "recwpwzgzp7pTHfMb", "fields": { "Name": "test", "Notes": "test" } }, { "id": "recjKjPPQqaXh60MH", "fields": { "Name": "test2", "Notes": "test2" } } ] } { “error”: { “type”: “INVALID_REQUEST_UNKNOWN”, “message”: “Invalid request: parameter validation failed. Check your request data.” } }

461
F
W
WidgeticKnown Participant
asked in Development & APIs
Too many re-renders

Hi all! I’m trying to read from two tables using useRecords which have a limited number of fields to create a stateful content variable which I have to pass on to the next react Component. Here’s my code const { translator, compId } = props; // Block viewport const viewport = useViewport(); const [editorVisible, setEditorVisible] = useState(false); const [content, setContent] = useState(demoContent[0].content); // Block settings button useSettingsButton(function () { if (viewport.isFullscreen) { setEditorVisible(!editorVisible); } else { viewport.enterFullscreenIfPossible(); setEditorVisible(true); } }); // read the current tables and translate the content to // 'content' object const contentTable = base.getTableByName("Content"); const detailsTable = base.getTableByName("Details"); const contents = useRecords(contentTable); const details = useRecords(detailsTable); const relevantDetail = details[0]; const myContent = conten

702
W
A
Albert_AndradeNew Participant
asked in Formulas
P
Phil_SalantNew Participant
asked in Other Questions
Can I create an Airtable view containing records not present in a “linked records” column?

I have a table with columns like: Name (Single Line Text) | Partner (Link to "Name") ----------------------- | -------------------------- John Doe | `Jane Doe` Jane Doe | (Empty) Bob Smith | `Mary Smith` `Kevin Smith` Mary Smith | (Empty) Kevin Smith | (Empty) Alan Stephens | (Empty) I’d like to create a new view for this table with filtering like: WHERE {Partner (field)} is not empty OR {Partner (column)} does not contain {Name} such that the result would be: Name (Single Line Text) | Partner (Link to "Name") ----------------------- | -------------------------- John Doe | `Jane Doe` Bob Smith | `Mary Smith` `Kevin Smith` Alan Stephens | (Empty) The challenge here is that on line 1 of my filter, I’m looking for “records with no records linked in their Partner column”, but on line 2 I’m looking for “records which are not found in the Partner column for any other recor

272
P
L
Lisa_weberNew Participant
asked in Other Questions
K
Kendy511Known Participant
asked in Formulas
L
Leslie_MillerKnown Participant
asked in Development & APIs
C
Chris_GuthrieInspiring
asked in Development & APIs
B
Ben_HInspiring
asked in Other Questions
D
Declan_PeachNew Participant
asked in Other Questions
D
Dominic_RannieKnown Participant
asked in Other Questions
C
Contact_Lights_New Participant
asked in Formulas
M
Michael_LeverInspiring
asked in Other Questions
W
WidgeticKnown Participant
asked in Development & APIs
Cannot create table

Hi all! I’m trying to create a new table using base.unstable_createTableAsync following the example in the guide. This is the code I’m using - const fields = [{ name: "MyField", field: FieldType.SINGLE_LINE_TEXT }]; if (base.unstable_hasPermissionToCreateTable("MyTable", fields)) { await base.unstable_createTableAsync("MyTable", fields); // and create records } But I keep getting the error Uncaught (in promise) Error: Can't create table: invalid field config for field 'MyField'. Creating or updating options for undefined fields is not supported at this time. at Mutations._assertMutationIsValid (bundle.js:formatted:7299) at Mutations.applyMutationAsync$ (bundle.js:formatted:6813) at tryCatch (bundle.js:formatted:94903) at Generator.invoke [as _invoke] (bundle.js:formatted:95131) at Generator.prototype.<computed> [as next] (bundle.js:formatted:94956) at tryCatch (bundle.js:formatted:94903) at invoke (bundle.js:formatted:94997) at bundle.js:fo

502
W
J
JonathanBInspiring
asked in Formulas
Logging the "history" of a checkbox field with a formula

Hi all I’m trying to find a way to record, within a table, an ongoing “history” of when a checkbox has been checked/unchecked. The first stage is simple enough, e.g. a formula field that outputs today’s date when the box is initially selected - IF({Yes/No}=“1”, DATETIME_FORMAT(TODAY(), “DD/MM/YYYY”), “”) but what I then want is an additional field that keeps a kind of tally of when the box has been checked/unchecked, i.e. “Approved 03/07/2020; removed 10/07/2020; approved 13/07/2020…” etc. I think it will probably involve using a “last modified” field but I can’t work out how to make the “tallying” part of the formula, rather than just updating each time there is a change. Can anyone advise if this is possible to do? Thank you!

813
ScottWorld
T
Taylor_JettNew Participant
asked in Other Questions
D
David_Gutierre1Participating Frequently
asked in Formulas
Running Countdown based on single select stage

Hello all! I want to have countdown (showing how many days left) based on the stage (a single select field) of a record. Each stage should take a certain amount of time to complete, so the goal is to see how many days left I have to complete a stage. Then once I change it to the next stage, that countdown is reset to the parameters of the next stage. I have parameters are mostly set by formula-based date fields that live in the table. So it would look something like this: If {Stage}=Stage 1, calculate difference between {date 1} & 14 days from {date 1} If {Stage}=Stage 2, calculate difference between {date 2} & 14 days from {date 2} If {Stage}=Stage 3, calculate difference between {date 3} & 28 days from {date 3} If {Stage}=Stage Complete, “Complete” I tried doing a DATETIME_DIFF inside of the If function, but have been struggling with errors. Seems pretty straight-forward, but I can’t figure it out… Any help would be great! Thanks in advance.

823
J
S
Sidney_MLNew Participant
asked in Development & APIs
M
MixableNew Participant
asked in Development & APIs
H
Helen_VaskevitcKnown Participant
asked in Other Questions
L
Luis_HMNew Participant
asked in Other Questions
Y
Yaron_AvramovInspiring
asked in Other Questions
Kamille_Parks11
Kamille_Parks11Brainy
asked in Development & APIs
No-Conflict Appointment Scheduler

Use Case: You have a table of stylists, therapists, technicians, etc. (“agents”) who perform any number of services, and customers are supposed to schedule an appointment with an agent to perform a service but only when that agent is available. While you think the No-Conflict Asset Reservations script is great, it doesn’t take into account your need to schedule an agent for more than one appointment per day. Solution: No-Conflict Appointment script by Kamille. An improvement upon my previous script, you can now schedule same-day appointments assuming those appointments don’t overlap. It allows users to select a service, pick a qualified agent/employee to perform that service, and then select upcoming dates and times which work for that agent. The script opts to use buttons as opposed to text box inputs to reduce human error in typing in correctly formatted date/time strings. Since there isn’t a datetime picker input type, I basically hacked my own using two conditional button inpu

1865
A
M
MixableNew Participant
asked in Development & APIs

Badge winners

Show all badges
Terms & ConditionsAccessibility statement