Well, I wrote all of this out, so I’ll still post it.
You mean whoever created the row in the produits-objets table?
First of all, your user table has row owners enabled on the email column and the bio column. I’m not sure why you have row owners set on the bio column, unless you plan to populate it with an email address.
Second, you have row owners enabled, so if I sign into your app, I will not have access your user row, so there is no way for me to get your phone number for the template column to work.
Third, do you plan to connect the row in the produits table to the user table to get the phone number? You can do that with a single relation and a lookup column, but you will still have problems due to the row owners. Also, I’m assuming you would use an email to create that relation, but you have a lot of empty cells in your rows, so I’m not sure how you indicate who created the row.
It’s up to you how you want to have the template get that phone number for the user who posted. How secure do you need your data to be? If you disable row owners on the user sheet, then all data will be exposed to anybody who uses the app, but at the same time, it seems like you want some of that data to be shared (or unsecured) among all users of the app. You could write the phone number to the produits table when the row is created, but it will not update if the user ever updates the phone number in their user profile. This comes down to how you think you want to get access to the correct phone number. I would take some time to consider your layout and the importance bof securing your data.
However, I have a question. If I understood correctly … if I have several email accounts but I send with the same telephone even if I assign a different number for each account Glide will only take one number. Is it true ?
I don’t understand the question. I don’t know how you are finally getting the correct phone number now. Whichever number it finds, based in the email you used to sign into the app, will be the number that’s put into the template column.
ok. I will need some time to answer because it seems I do things without knowing the deep reasons behind what I am doing.
This first app I am working on is a simple old Bookstore. I plan to add some users that will also posts some books. I will also add in the future other types of collectibles.
I red in a post that Row Owners are important for all tables so I created Row owners.
I red that you cannot do certain things with GS so I am using Glide tables.
It seems that over 25000/40000 rows The application runs out of steam even if you find ideas.
So if I need 100000 or 200000 (this my next project) should I have 4 apps or more. It seems that synchronicity works only with simple columns not computed ones. So I am trying to do things without computed columns.
…
The most important thing at this stage is to give buyers the opportunity to contact users who have the right to post products.
Basically I created a Whatsapp store but it does not have a Search function so I decided to work with a no code platform. Whatsapp remains important in my communication strategy. Not only. I still have a Whatsapp business account with 200 products but I do not yet know how powerful it is. The Whatsapp shop need a lot of functionalities to be efficient.
Do you happen to know if the solution above can be tweaked to open a What’sApp group (versus messaging a single person)?
The reason I ask is because I have an App that replaced a What’sApp group to help manage and organize a sport’s team. The team still uses What’sApp for instant messaging… so it would be great to add a button or link that could open the group directly.
Separately - and I’m guessing this is not possible (with no code options) but here goes: - what about drafting a message ready to send, i.e. like the glide feature to draft a new email.
I don’t think this is possible since WhatsApp only recognizes the phone number as the main ID and communications are 1 to 1. On their help site there are two solutions: the one with which I opened this wire and this one: https://wa.me/XXXXXXXXXXX?text=I’m%20interested%20in%20your%20car%20for%20sale
You can create a message (even a very long one I imagine) to a XXXXXXXXX phone number. The space between words is separated by the characters %20 for encoding.