I have a joined list that is created from combining all values in a Contact Phone number column. When a user adds another Contact through submitting a form, I want to check if the contact is already in the list of existing contacts. So, in the action for submission of form, I try to create a If con…

@vijay here is an example of what I mean: [image] How do I create a custom form? FAQ I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom f…

[image] vijay: I try to create a If condition to check if the number to be submitted is included in the Joined list, but I find that when I try to do that, the column for Number doesnt appear. Is it that you cannot compare a number value with a joined list? No that won’t work. If your goal i…

I create a relation column “Contact Relation” which relates Contact Phone Number with Contact Phone Number in the same sheet. Then, when user is adding an item using the Add button on the top of a tab, during submission I have the check using condition Contact Relation is empty, but it is not checki…

Yes, that’s expected. If you’re using Add Form then the relation won’t be formed until after the new row is added. In order to use this technique, you need to create a custom form and write the input number to a User Specific Column. Because USC’s are populated as the user enters the data, the relat…

I made the phone number user specific. But, now it is not showing up when I try to add a number entry to the phone number column. Is it because, it is user specific? I created a form button and then tried to add the two fields. Only the txt field for name appears, but not able to select a number ent…

What @Darren_Murphy means is you should use a link to screen action, then add entry components and use an add row action to have the same flow as a form. With your screenshots, you’re trying to write to a user-specific column in the destination sheet, which will not work.

Thanks for the app which helped me understand how it can be done. But, when I tried the same thing, I find that when I try to Add Row, I am not able to see the components usc name and usc phone number. I created usc name and usc phone number to store the entries temporarily as you have done. I also …

Which table did you create the User Specific Columns in? By looking at your screenshots, they should be in your Contacts table. Also, I would advise always using a custom action - even if it’s just a single action. Because inevitably you will come back later and need to add extra steps. If you sta…

Yes, there are in the Contacts table. [image] [image]

And your Phone Entry and Name Entry input components are targeted at those User Specific columns? That should work.

Yes, it is, but strangely, the columns are refusing to appear. [image] Does it need some data to be entered for it to appear?

Not able to check if a number is included in a joined list

Ask for Help

Darren_Murphy May 13, 2021, 3:10am 7

@vijay here is an example of what I mean:

Topic		Replies	Views
Duplicate rows Ask for Help	3	266	January 22, 2024
User Specific Columns + User Profiles Demo Community Resources tutorial	89	5462	May 31, 2020
Solution to Prevent Duplicate Entry Ask for Help	85	8692	October 22, 2023
Unique row for signup form everytime for every user Ask for Help	6	455	March 27, 2023
Enforce column value is unique (distinct) Ask for Help	26	1667	September 24, 2024

Not able to check if a number is included in a joined list

Related topics