There is a login (unique) and password from the user. The easiest way is to filter the data: load all the rows from AirTable to list and then in a cycle to select data from list that matches the login field. Why do you need an identifier if there is a unique login?
Thank you! The reason I need a unique identifier is because several people with one unique identifier will see certain information, while other people without that identifier won’t, I need to be able to seperate this data across people dynamically,
And is it suitable for you when you use public free admission? If user registered and have a login - we show one, and for unregistered users - another.
Now I understand. Then you need to supplement the entry with a unique company ID. In our country it is an INN (a unique identifier of the taxpayer). When a user registers he enters INN and the program checks whether there is a company with such a INN or not.
Authorization of the company is a complicated process. Everything depends on the level of information secrecy. These are already issues of data security. Someone from 7 users can give their friend a login and password.
I think it’s more practical for you to issue a company ID. Then the user will enter not his login, but the login of the company.
Jacob,
I also need to retrieve a specific record (all columns) from my Airtable; I can use a key (email example) but between Spreadsheet GET component the only filter is the ROW.
How I can know the row of a specific record?
I read actech answares but I do not understand how to do it.
Many thanks
Andrea
It sounds as though you have similar problems. I wasn’t able to pull back on individual emails - but I could do it with one username and one password per company using google firebase and the “sign-in” component - please let me know if this suits your needs and I can assist
You can filter entries from AirTable by any number of any fields. Also each record initially has a unique identifier in addition to which you can create your own fields with unique values.
To solve such problems, you first need to create a general scheme MVC (Model-View-Controller) on paper. Then it becomes clear what data and where to use, how to show them and how to link the data in the table with their display in the application.
Ciao actech,
no problem to select a single record pointing the row number … but how do I know what the number of records is?
for example … I have a address table with email in key … I need to get just one record that have a specific field data so …
Maybe you say to parse all record filtering? could you show me a block ?
First of all you need to get all records from a table in a list with a block of “getAllRows”. After that, local storage will contain all data from the table and they can work on any screen. List filterList stored filtered on two fields a “email” field and Age. This list is assigned to the ListViewer and it displays only the values for the field Name (values of _id non visible). Selecting from the list with the value of the Name field is also a unique key of _id entry in which the entry can always be found.
Working with the list of records is less effective than database queries. But the algorithm shown is universal and requires only one query to the database to retrieve data. After that you can do with the data whatever you want.
in your solution you copied the rows from the DB to the list “filterList” in the local memory of the app. how do you initialized that local list? how to determine the number and the type of the columns?
what if i manage my DB in airtable and i store pictures there, can this script copy those pictures to the local table?
as i understand, instead of insert hardcoded email address, with the sign in we can store the email of the user in global variable and use that variable in order to retrieve the relevant data?