Help

Re: Modify AirTable ID

1791 0
cancel
Showing results for 
Search instead for 
Did you mean: 
STEPHANE_BARBAG
4 - Data Explorer
4 - Data Explorer

please, I need help.

  1. The id created by airtable for each of my entries does not suit me and I would like to replace it with the entry of my column ID! How to do?
  2. How to make a single entry? when one of my clients chooses an ID I do not want another one to choose the same one!
11 Replies 11

Welcome to the community, @STEPHANE_BARBAGELATA! :grinning_face_with_big_eyes: I’m not sure what you’re asking.

  1. What do you mean by “the id created by airtable” and “the entry of my column ID”?
  2. When asking about making “a single entry,” are you talking about a single new record?

Could you please provide a more detailed example of how your base is set up, and the specific issues you’re having? I understand that you’re new to the platform, but it would help us to understand your specific issue(s) if you use terms as defined by the Airtable developers. Tabs in an Airtable base are tables, columns in a table are called fields, rows are records, etc. It may help to review this page (and subsequent pages linked from it) for more about the terms used by Airtable:

STEPHANE_BARBAG
4 - Data Explorer
4 - Data Explorer

Hi Justin and thank you answering
sorry not to be very clear.
So
I’ve created a simple base with a single table.
Just 4 fields.
First field is product ID.
I want my field ID to replace the default record id made I suppose by JSON…

I hope I’ve been clearer

Thanks

Stefanu

STEPHANE_BARBAG
4 - Data Explorer
4 - Data Explorer

I’ve made a picture to be clearer but can’t put it in a post…

STEPHANE_BARBAG
4 - Data Explorer
4 - Data Explorer

“records”: [
{
“id”: “rec9qvoBLsgJ77rxh”,**
“fields”: {
“Entrez ici vos données de contact”: “0600000”,
ID": 10001,**
“eMail”: “mail@gmail.com”,
“Comment souhaitez-vous être contactés ?”: “par téléphone”,
“Téléphone principal”: “070000000”,
“Objet”: “mon téléphone”,
“Nom”: “Name”,
“Prénom”: “Stéphane”
I want to replace rec9qvoBLsgJ77rxh by 10001

STEPHANE_BARBAG
4 - Data Explorer
4 - Data Explorer

For the 2nd point

I need my ID to stay single when clients are creating a new record
How to make in the ID column double entries impossible ?

STEPHANE_BARBAG
4 - Data Explorer
4 - Data Explorer

Sorry about all of this questions … first day with airtable… and not very good English speaker by the way

Thanks for the clarification. I’m going to move this discussion to the API category, as it’s probably more appropriate.

New community users have certain restrictions in place. Once you’ve been active here for a while, the system will gradually start lifting those restrictions.

The “recxxxxxxx…” record ID created by Airtable cannot be changed. That’s a randomly-generated ID that’s used to ensure record uniqueness, even if the visible data in your primary field somehow ends up not being unique between records. You can obviously add and edit your own ID field for your own purposes, but that Airtable-generated ID is permanently assigned to the record.

One of the easiest ways to accomplish that is to turn the ID field into a formula that uses an Autonumber field to calculate the number. Say you added an Autonumber field named {Autonumber}. The formula for the ID field would be:

{Autonumber} + 10000

Because Autonumber fields begin at 1, the ID value in the first record would be 10001, then 10002 for the next record, and so on. No duplicates ever.

STEPHANE_BARBAG
4 - Data Explorer
4 - Data Explorer

Ok… thank you so much for your answers… so I’m… dead !
Because I have to program RFID chips with an url like myweb site. com/ID … if I do not know the ID… I can’t use Air Table…
However … Thanks a lot !

STEPHANE_BARBAG
4 - Data Explorer
4 - Data Explorer

Okay … I may have found a solution. If I create all the records (only the ID field), can the customer fill in the other fields? because I tried and I got two lines with ID 10001 one filled and one that I had created with the only ID …
Thanks again…
Stephane

I want to cretae them to know the air table record ID before… and program my chips to the URL : mywebsite. com /recXXXXXX

Not using Airtable’s native forms. Airtable forms always add new records. They currently can’t be used to edit existing records. For that, you’ll need to use a third-party form tool like Jotform or Typeform, and route the output from that form through either Zapier or Integromat to update the appropriate Airtable record. You might consider posting to the Work Offered category to get help building this system if you don’t feel like you can do it on your own.

I’m confused. If you’re using an Autonumber field and a formula to create the ID values as I suggested earlier, duplicate numbers are impossible. Autonumber never duplicates numbers, so the final number created by the formula will always be unique. Could you please describe what you did in greater detail?