Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 05, 2019 02:02 AM
please, I need help.
Dec 05, 2019 07:20 AM
Welcome to the community, @STEPHANE_BARBAGELATA! :grinning_face_with_big_eyes: I’m not sure what you’re asking.
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:
Dec 05, 2019 07:47 AM
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
Dec 05, 2019 07:49 AM
I’ve made a picture to be clearer but can’t put it in a post…
Dec 05, 2019 07:53 AM
“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
Dec 05, 2019 08:01 AM
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 ?
Dec 05, 2019 08:02 AM
Sorry about all of this questions … first day with airtable… and not very good English speaker by the way
Dec 05, 2019 08:42 AM
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.
Dec 05, 2019 10:45 AM
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 !
Dec 05, 2019 11:17 AM
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