วีดีโอ

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

You are welcome

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...

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.

Thanks so much.

What do you mean by this? Like an EnumList?

@@FullOfSheets I think it's like dropdown 1: I select the book item then dropdown 2: I select mathematics, physics, chemistry. dropdown 3: is a branch of dropdown 2 (branch of mathematics, physics, chemistry. If I select physics and chemistry both branches of the book will appear in dropdown 3. Can I make it like that?

I see. So the second dropdown will be an EnumList. The process demonstrated in this video will not be bale to do that. But what you want is still doable by using a Filter() or Select() in the Validation of your third dropdown. I'll see if I can make a video for this.

@@FullOfSheets Does this happen continuously? or just getting there? thank you for helping me

Sorry, I dont think I understand what you mean. Would you care to explain.

It's coming this week. 😊 I'll give you a shoutout in the video. 🤗

​@@FullOfSheets awesome!! Can't wait for it!! 🎉🎉

It's up now. 😊

Which one?

This is true. What you described is exactly what I do back in the days with Microsoft Access. But if I remove all other task information in the #Tasks# table and only have the [Project ID] and [Member ID], then it is what you already described. But I must say, even in an Orders App where a many to many relationship is made between an #Orders# table and a #Products# table, additional columns are used in the join table for #Order Details#. This would invlude the qty, and line total for each product added in the Order form's child table.

Thanks for the feedback. I do have an Audio Tecnica A2020 mic. However, I find it challenging to move freely with a big mic in front of me, even if I am using a mic flex arm. I found it easier to move using a wireless lapel mic, and the spund quality is acceptable enough for the viewer. The sound can still be improved in post-processing, but unfortunately, I don't have all the time resources to edit the video. Would you believe I actually only edit my videos in Samsung phone using a free Capcut app? 🤣 Maybe one day, if I make enough money, I can start hiring editors. But for now, I thank you for your patience in understanding the quality of my audio.

Most often than not, it would be on the condition to stop the loop that may trigger this infinite loop.

Glad it was helpful!

It can, the problem is that the action buttons are not accessible in a form view. So you will have to save the form first, then click the button in a detail view, or in a table/deck view while the row is selected.

Hi, You are correct. You cannot avoid duplication of the same task to the same student by using the Task ID as the primary key. If you need to have this ensured, you have the ff. options: 1) Composite key This a combination of two fields as the primary key. In your case, a combination of the task name and the student ID. This can be done by: a) a virtual column b) a Physical column using an app formula c) a physical column using initial values The disadvantage of options a and b would be that the name and student id would not no longer be editable after the inital save. The disadvantage of option c on the other hand would be that the key would not he updated when either of the name or the student id columns are edited. - although this can be worked around by turning on the Reset on Edit option. 2) Valid If expression You would still use a combination of two columns in a helper column, probably a hidden virtual column. You then use a valid if expression to check that the helper column does not yet exist in the table. For example, let's say your helper column is called [Name_Student]. Then in the Valid If of either the [Name] or [Student ID], you use the ff expression Count( Filter("Tasks", [Name_Student]=[_THISROW].[Name_Student]) ) <1 Hmwoukd help if you also put a custom error message telling the user that a task with that name already exists for the same student.

Yes. Yes. I know! 🤣 Still working on itm really sorry. I need to find time to edit the videos.

I will have to check if I can do an update for the video. It is a very rare use case to have this capability but it is doable by using loops within loops, meaning one of the steps in the loop group, is another loop group. There will be some hidden virtual columns needed to monitor which combination values already exist in the child tables.

Simply add the name of the member in the slice youbuse for the Project's child task table.

Replied in your last comment. 😊

Awesome, thank you! Welcome aboard!

Do you need a dynamic enum or jist a validation that the date has not been used in another entry?

I was thinking of having the enum change its choices depending on the date and time available, example if i select the date it would only show the available time slot

Is your timeslots Enum values being pulled from a separate table or did you supply the values manually in the enum's column settings.

You are welcome!

Thank you! Cheers!