I'm having problems when one data tab in sheets has dynamic dropdowns that use type Refer and when I create a document (pdf) the Worker and Contractor from other tabs a referenced using the ID column and I want to see the Workers Name and the Company they work for not the unique ID for each. Any ways I can do this? Looking into other wanys to create dynamic dropdowns without using Ref types
Hello sir, is there anyway to auto fill in a variable information in a list added in the drop down list. Say for example, I have added Login Time (insert time). And then when I choose that option, I want the option to automatically include the login time inside the parentheses (just like this: Login Time (08:00AM)) . Is there any way to do this in appsheet? Thank you in advance!
Hello! I am new in AppSheet, thank you for your video; it helped me to create something similar, but I receive an error in the form, when I select, as a test, a data from the dropdown list, a message :"this entry is invalid"; in the formula I have no error. Could you tell me what it means; the both field, the dropdown list and the field to be autofilled are with this error. Thank you for your help!
@@JoeTayactac Yes, I put a formula in order to get a dropdown list, as I saw in other video to create a dropdown list. I understand I am wrong using this king of creation of a dropdown list? Thank you very much!
Could you please tell me, what video should I watch to make this change? I used validate-if with a formula that shows the table name and column name from which I need to display data. Thank you for your help!
its easy when employee ID is only 10 or 20 items, but how when the employee ID data is 1000. how to replace combobox dropdown button into search text and we put manually search employee ID ??....TQ
Hi You can add a Virtual Coloum in Employee Details and make it as a Label. Then apply an app formula Concatenate([Employee ID],"-",[Employee Name]). Then in dropdown you will have a result 1256-Joe
Hi.. I need your advice to set up a view. I need to mention a total number of inventory available based on a view created for each product type. Request you to share your email / whatsapp number in the comment reply to explain the issue in detail.
Thanks you, for sharing your video. Great
Thank you! just what I needed
very informative thank you for the uploading
Thank you, very helpful, I didnt try it yet but I hope it works
I'm having problems when one data tab in sheets has dynamic dropdowns that use type Refer and when I create a document (pdf) the Worker and Contractor from other tabs a referenced using the ID column and I want to see the Workers Name and the Company they work for not the unique ID for each. Any ways I can do this? Looking into other wanys to create dynamic dropdowns without using Ref types
Thanks form Honduras
Thankuou so much this really help
Your welcome
Me ajudou muito. Parabens
is there any way to use this function when editing an already made row?
Thank you so much for your videos. Im a App designer, this helps a lot for the development. If I need any help from you, where can I contact you ?
Hello sir, is there anyway to auto fill in a variable information in a list added in the drop down list. Say for example, I have added Login Time (insert time). And then when I choose that option, I want the option to automatically include the login time inside the parentheses (just like this: Login Time (08:00AM)) . Is there any way to do this in appsheet? Thank you in advance!
i need your help to correlate the last stock of the provious day equal to opening stock for next day morning
Reply
I dont speak english but i I think I understood, thanks
Hello! I am new in AppSheet, thank you for your video; it helped me to create something similar, but I receive an error in the form, when I select, as a test, a data from the dropdown list, a message :"this entry is invalid"; in the formula I have no error. Could you tell me what it means; the both field, the dropdown list and the field to be autofilled are with this error.
Thank you for your help!
Try to check in valid if section (Data Validity)maybe you put some formula
@@JoeTayactac Yes, I put a formula in order to get a dropdown list, as I saw in other video to create a dropdown list. I understand I am wrong using this king of creation of a dropdown list? Thank you very much!
Then you need to fix your drop down list formula
Could you please tell me, what video should I watch to make this change? I used validate-if with a formula that shows the table name and column name from which I need to display data. Thank you for your help!
It works like this, as dropdown list, if I don't set the Type as "Ref"; but if I set as Ref, it doesn't work well anymore. Thank you!
🔥🔥🔥🔥🔥🔥
Thanks! It's possible that one person send me a QR code and when I scan, automatically complete 1 or more columns ?
nice work
hello, can I ask, i want to look up the value but the value isn't text, it's date, how can I do it? It's error in me. Thanks
Can I made Auto Fill Data Columns in Google Form?
It did not work for me either... Everything goes fine, but it returns an error saying [_Thisrow] does not contain a reference. :(
Hi,
I have an updated version of this
ruclips.net/video/24hAL_QtC2I/видео.html
its easy when employee ID is only 10 or 20 items, but how when the employee ID data is 1000. how to replace combobox dropdown button into search text and we put manually search employee ID ??....TQ
Hi
You can add a Virtual Coloum in Employee Details and make it as a Label.
Then apply an app formula
Concatenate([Employee ID],"-",[Employee Name]). Then in dropdown you will have a result 1256-Joe
@@JoeTayactac Thank you so much for your help.
Done idol
formula not working on mine
How is your table stracture?
As far as I can tell, this doesn't work.
Hi.. I need your advice to set up a view. I need to mention a total number of inventory available based on a view created for each product type. Request you to share your email / whatsapp number in the comment reply to explain the issue in detail.
Please check my youtube about page