Hi all
I am building a site with SOFTR that will give access to information about one’s home, made available by the building manager. The building-administrator first creates one or more records in the condominium table, then sends invitations to the email addresses of the various users. At that point he has to match the user to the buildings: I have a table representing the accesses of the various users to the various buildings (a building has many users, and one user, potentially, could have access to the data of multiple buildings!).
How can I use SOFTR to insert a record in this AIRTABLE table, which has two foreign keys, making it possible for the user to visually select (recognizing from text and photos!) the buidling and the user?
Any suggestions? I will be indebted if anyone comes up with a solution!