Thanks, bro! Hello Pakistan!!

You mean, in the appointment table, there is a dropdown which is a Ref type column pointing to #Patient# table's [DNI] column? Basically in the dropdown, you search for the [Name] which is the label for t #Patients#, right? Is what you want also to be able to type in the ID in that same dropdown instead of the label?

If you're not goung to use a dropdown, what are you going to use then? How will the users be able to select the option based on the previous field?

That's a great idea for a future video! Thanks for the suggestion!

Without much info about whatyou're trying to do, this is how I imagine it to be: You have a users table with the email addresses and names of the users. You also have a time in table with the following columns: [UserEmail] [DateTimeIn] [TimeInLocation] Initial valies are set as follows: [UserEmail] => USEREMAIL() [DateTimeIn] => NOW() [TimeInLocstion] => HERE()

I'm glad it helped! 😊

Then you need to make the PIC as the label for the table being referred to hy the dropdown. You can also select a text and an image column as both as labels. Appsheet allows more than 1 label as long as one of them is an image type column. Then, you can show data for that pic in ither columns using dereferencing. You can watch my video for dereferencing to learn how to do it.

Thanks. 😊

Thanks

First of all, thank you. To your question: Since you are using enumlist, then you will have to use a combination of SELECT(), IN(), and [_THISROW]. For example, your valud if expression for EnumList 2 can be: Select( TableName[Column Name 2], IN([Column Name 1], [_THISROW].[Enum List 1]) )

@@FullOfSheets thank you so muchhhh(:

You're welcome!

Hmmm, if the data that needs to change are those coming from the actual tables, then you will need to jave different views, then show/hide the views using conditions based on usersettings. This is a lot.of work. 😁

Thanks I made it work by making another table for each for the language switch and left the valid_if statement point the the enum list

Awesome! Woot! Woot! 🎉🎉

It's my pleasure. Thank you for your support.

No need Simply put in a line feed. For example CONCATENATE([COLUMN], " ", [ANOTHER_COLUMN])

@@FullOfSheets ... THANKS A LOTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT

You're most wrlcome.

You are welcome

You will have to use Valid If expressions for each of those columns. I have a separate video on Dynamic Dependent Dropdowns. Check that out.

You're welcome!

If you want to delete all child re ords when the parent record is deleted, you have to tick the "is a part of" checkbox in the column settings of the Ref column of the child table.

You're so welcome!

Sorry, i didn't quite get what you mean.

@@FullOfSheets sorry, i mean If we use valid if, how to Make another choise? We want to automatic if select A sub is Aa Ab but how to create new option in sub, Ac...

I think your last response was clipped or unfinished.

Check if you have more than 1 field using the Valid-if and getting from the same table. It would create a dynamic dependent dropdown, which would make the field invisible until you make a selection in the very first cilumn that uses Valud-If from that table.

@@FullOfSheets I found that if the table used for the dropdown is blank, then the field doesn't show. As soon as I entered data in the dropdown table, the field appeared. Thank you for responding.

I'm glad you figured it out. 😊

Unfortunately not. It will accept newly added cities, as well as show it as part of the options mv9ng forward, but it will not be saved on the actial Cities table. Only Ref type columns would allow you to do that.

You can't. Every time you want to accept entries, those fields should be separate columns in the GSheet table.

@@FullOfSheets Thank you

You're welcome.

Sorry, I didn't quite get that. The Fixed Name and Phone Number is in the same dropdown menu?

@@FullOfSheets drop-down menu: Mario:__________ Stefano:__________ Anna:____________ Paolo:_____________ where there are hatches I want to be able to insert the number

@@FullOfSheets drop-down menu: Mario:__________ Stefano:__________ Anna:____________ Paolo:_____________ where there are hatches I want to be able to insert the number

@@FullOfSheets drop-down menu: Mario:__________ Stefano:__________ Anna:____________ Paolo:_____________ where there are hatches I want to be able to insert the number

Already replied on the other comment thread.

When you say username - did you mean the email address, or is it the actual name of the user?

It is awesome. 😇

Enum-Ref would only have A search bar. It wkukd not give search and add. However, Search bar will bot appear if the option values are few enough to fit into the screen.

What did you mean by this? The only thing linking the 2 is the key of the main table also present in the related table. If you change it in the related table, then it would break the original link. Which changes in the related table are you thinking to change that should also change in the main table?

Thanks for the coffee treat! I appreciate it! 😊

Glad it helped. 😊

Glad it was helpful!

Wow. Thanks, man. I'm happy you like my style of teaching. 🤗

I know i know. I'm sorry. I'm only using a cheap wireless lapel and it was cutting lut every now and then, so I had tonredub some words that were inaudible. Will try to do better next time. But I hope it wasn't too much of a hindrancr for you to understand the concepts I was sharing.. was it?

I will probably release this as separate shorts. But we'll see. Thanks for the request.

Thank you so much! I really appreciate it!

Ref will also .ake a dropdown but with an option add a new value in the underly8jg table of the ref. Text + Valid if will only limit you to the existing options in the drop down. Ref also creates a relationship which will automatically create a [Related Records] virtual colum in the other table. Text +Valid if will not.

Thank you! I appreciate it! 🙏

Cool, thanks!

It can be. Because AppSheet will fetch data on each sync. You can try to turn on caching so that this will be minimized. Settings > Performance: Server Caching: On Delta Sync: On Settings > Offline mode: Store content for offline use: On

Thank you

Welcome

What is the name of the columns of the prev day and new day stock? And what is the name of the date column?

This would most probably because of the formula you set for the first action. You have to make sure that the [first list] - [related list][column] = list not yet added. You may want to test it out by adding a virtual column you can see as the loop goes. For example, add a virtaul column called [myVC] where the formula is [my Enum List] - [my Related List][my column to check] Then, on the expression of your first action, simply use INDEX([myVC], 1) And on your loop stopper expression, use ISNOTBLANK([myVC]) The [myVC] will be updating for each loop, and you can see what happens on each iteration.

@@FullOfSheets thanks for answering! I need to stamp a progressive row value (1,2,3.. etc). The condition for how many rows to attach depends on total rows number question on the form. Right now i tried different ways to do that, even automations, but after the second row, it overwrite the first one with other values (3,4,5 or more). I can see it as it goes. At the end, the first row has the last number value, the second row has the number 2 (and this is right)

So you mean there is no EnumList that would be the basis of the number of rows added, right? Would it then be a number column asking the actual number of rows to be added to the child? And what i formation from the parent would be transferred to each child rows?

You will have to elaborate what you meant by updating header, sir. 😊

@@FullOfSheets i was trying to create an update function for parent table that will automatically change also the child row status.

Your best bet would be an automation bot triggered on the main table 's Update event, and then a data change action process.

Thanks so much! I appreciate that. I do. I have a link in my channel description. Just a heada up, though, I currently have several bookings on queue, so please expect a little delay before I reach out - in case you'll be interested in my services. 😊

That is the downside. Since this Looping demo only focuses on the initial creation. Succeeding edits do not update the child records. That would require a different action or automation.