Multiselect Lookup Count
I have read several threads/forums on this but cannot figure out how to do what we need. We have an Zoho Creator application with a subform for Hotel Reservations for our clients. In the subform there is a Lookup multiselect from another database to list all employees available to be added to a reservation. I have tried various code and nothing is successful. We have a field named "Number" that we want to count the total number of employees selected from ProCon Employees multiselect lookup.
Setting up multiple alerts/notifications
Hello, I've created two instances: Customer and Order. Now I'd like to set up multiple notifications by mail for every order by a DueDate field (say 7 days prior to DueDate, 3 days prior to DueDate and at the DueDate). Could you guide me how to do that? I'm not a coder, so please be gentle Thank you very much
How to Create a Link to Jump to a Specific Part of a Page
Hi is this possible on zoho creator pages? here is simple html code <a href="#c4">Jump to Chapter 4</a> <h1 id="c1"> Chapter1 </h1> Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Nulla quis lorem ut libero malesuada feugiat. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Cras ultricies ligula sed magna dictum porta. <h1 id="c2"> Chapter2 </h1> Curabitur aliquet quam id dui posuere blandit. Donec rutrum congue leo eget malesuada. Curabitur non nulla sit amet nisl
AIRPORT TRANSFER BOOKING SYSTHEM
Hi guys i just start using zoho creator to manage my transportation booking management company. I have built two booking forms, one that i'll embeded in the website and one for the registered companies. 1st problem: don't know how to auto fill corporate customers details from contacts list to the booking companies booking form . need help!!
Custome Theme
How Can I change the theme of my page and create a costume theme with my company colors and logo.
Add/Edit/Store multiple forms within a form
I have created a form to keep track of a project. I have fields such as: Address of project, Contact for project, special instructions for project etc. What I need is a way to store multiple purchase orders within a form. A purchase order will contain information such as the product, the number of pieces, the weight etc. I can use a sub-form but in reporting it only shows up as a link. I need a report that shows all the details of each PO not just a link to details. Does anyone know a solution for
Zoho creator account issue
Hi, I just upgraded my zoho creator account to professional, but my account type is still on personal free. Can you please advise me on what is wrong. My account email is adrien@nova-ix.com.
Add multiple fields to a dropdown list
Hello, I am hoping someone could help me out with a problem I am having. I would like to add two fields separated by a ( - ) to a dropdown list in a subform. This code, jobs = New_Project[ID != 0 && Job_Status == "Open" && Job_Type == "Construction" && Client_String == input.Owner]; Crew_Time.Job_No:ui.add(jobs.Job_Number.getall());returns a list which looks like this: S17565 S17586 S17585
Global Search results not rendering properly
I've just noticed now using the global search box in Zoho Creator is not displaying the results correctly. The results are found but the records are not displaying. If you click on them you can View and edit fine. Normal search on individual fields of separate reports works fine. Just the global search box has this problem all of a sudden. It used to work fine and is a really handy feature. Have tried this on my app in other browsers and computers the same thing happens. The only thing I changed
Can I change the sender name?
Dear Zoho Community, I would like to change my sender name in the emails that I send once mi user filled in the form. Currently I am using the zoho.adminuserid: from:zoho.adminuserid to:input.contact_email When the user receive the email, the sender name is the email, Can I set up the sender name to show it instead of the e-mail address? from: xxxxx@xxx.com via usermail.zohocreator.eu I would like something like this. from: <Name of the company> xxxx@xxxxxxx.com via usermail.zohocreator.eu
How to get account name in drop down in creator
I get all enabled account name in drop down in creator ....
Zoho Creator - Customer Portal Mobile Access
Hi, Just wondering if there is a way to access a Customer Portal via mobile site as per other Zoho Creator app's? EG: m.domain.zohocreator.com Also, it appears it doesn't work correctly with IE8? Please advise. Thanks Troy
Error in if function
I am trying to make a simple if function, but apparently something I miss as I get error when saving if (input.PF_Deviation < 24) { input.Delay_Status = On Time; } PF_Deviation is a formula field subtracting two time stamps, hence the the result should be that Delay_Status (drop down) should read On Time when less then 24 hrs. Any tips?
Error occurred please contact the application owner
For some reason my form stopped working the other day I cannot figure it out for the life of me. I select a drop down and it just breaks. An error message pops up that says "Error occurred please contact the application owner" Is there any good way of debugging the issue? I've put alerts all over the code trying to figure out when exactly it breaks and I'm still not even sure I fully know where it is breaking. Any help would be appreciated.
Adding an approval process
Hello I am sure this will be easy to fix - just haven't found the right answer yet! I have created a very simply form for entering website details. The details entered will then be listed in a publicly viewable grid. However, before enabling the public view for the grid, I would like to add a step where the entries submitted will need to be approved by me(the db creator) before they appear publicly. How do I enable this? Many thanks in advance H
Convert a numerically string into a decimal
Hello, I have a problem, converting a decimal like durations_of_days = 1.7825321 into a rounded decimal with the result of 1.78 In ZOHO Creator this works: durations_of_days_string = "" + (durations_of_days * 100).getPrefix(".") -> result: durations_of_days_string = 178 But in ZOHO Creator, for example, this does not work: durations_of_days_rounded_decimal = (0.0 + durations_of_days_string) / 100 -> result: durations_of_days_rounded_decimal = 1.78 or perhaps durations_of_days_rounded_decimal = durations_of_days_string.getNumeric
Is it possible to use zoho creator on multiple devices simultaneously with a user?
As we are planning to use this application for internal, we don't need any access control right. So is it possible to share user account with multiple devices? Thank you very much!
Tutorial Error
Hi guys, I'm making the Pizza Order tutorial, but the wizard is getting stuck on the part where I'm supposed to add entries to the pizza order's form. No matter how many orders I input the wizard never advances. I've added over 20! It's stuck on this message: Here's your Application This is what people will see when they're using your application. In the final small section of the tutorial, we'll walk through how your pizza orders get stored. Go ahead and fill out your form a few times. SKIP TUTORIAL
null value for fetching record
Hi, I am getting Null value while trying to fetch a record from sub form of lookup field. how to address this Attached screen shot fyr Regards Janaki
1:1/1:Many Relational Issue
Hello - I am creating a simple inventory tracking app. I have two forms: 1) Form A, which shows Form B and a Quantity count, 2) Form B, which contains Manufacturer and Product Name. On Form A, I used lookup fields for the two fields on Form B. On Form A, when I click Manufacturer and "Add New", I get a full display of Form B, versus the single field I selected when creating the lookup field. Any idea why this is happening? (I am very new to Creator so I'm starting simple) Thanks for any help,
Zoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around
Not getting the url Link in PDF attachment
In PDF attachment the url field is added but the url field is showing me as a underlined text in PDF.When i click those text nothing is happening just like a normal text.How can i get the link in PDF which i given in url field.
Creating login for member
How can i create a login area for members and able to send them login id and password? thinckchina
I can't create my first app
Hello, I'm trying to create my first application in Zoho Creator, but I get the next error: Someone can help me please? Thanks
zoho creator and zoho forms difference
hi! can you explain what is difference between zoho creator and zoho forms. many years use zoho creator as internal database. for what purposes usually people use zoho forms? and what business and technical tasks zoho forms solve?
Joining multiple forms
I have just started using Zoho Creator. I have a very long application form that I have split into multiple forms. How do I connect these forms so that they behave as a single form?
How can I georeference forms automatically?
Hi guys, I want georeference automatically the forms and then put this field in Record Summary? if possible create this? Regards, Manuel
Time zone in report pdf
I am trying to export a report in .pdf format. Thought my application settings show IST time zone, the time zone shown in the report header is GMT. How can I change the time zone in the report header as well ?
I think I'm looking to create subforms
Can I create subforms with Zoho? Or perhaps there's another way to accomplish what I'm after. Basically I want to enter demographic information about clients, customers, etc. which could include multiple phone numbers, multiple email addresses, repeat purchases, etc. all on one form. Is that an option or do I have to switch from form to form and link them all? Form 1 - Name, address, date of first contact Form 2 - Email addresses Form 3 - Phone numbers
Calendar from date field is not displayed completely on phone screen
Hi Everyone, I made the Visitor Sign-In form as described in the "Creating an Application" video from the Zoholics videos and ran the form on my Samsung Galaxy S7. The form displays correctly but if I tap the date field, only half of the calendar is displayed on the phone screen. What do I need to do to centre it on the phone screen? Thanks. Truly, Emad
Can I not add multiple formula fields to another block
Hi, I have used formula field and calculated a percentage. I have used the output of this field to calculate one more percentage. Now I want to add all these into another field - obviously a formula field. However, in the refer fields block these fields are not visible. Ex: formula field 1 = ((9/100)*CTC) Formula field 2 = ((5/100)*formula field1) Formula field 3 = sum of (formula field 1 + formula field 2) - however I am not able to view these options under refer field in the formula field pop
Enable and disable the “Enable Payment” checkbox in the “Payment” form settings from within Deluge
Hi, Can I enable and disable the “Enable Payment” checkbox in the “Payment” form settings from within Deluge? I need to do this so I don’t need to create duplicate forms with the only difference being to accept PayPal payments vs payments by cheques. Thanks. Truly, Emad
"Set Filter" for lookup fields inconsistent implementation on web v's mobile app
Hi, When using the "Set Filter" option on a lookup field in the mobile app it will update the lookup when I update a dependent field via deluge. In the web browser this is not the case, filters will only get invoked when a dependent field is updated manually. Effectively I now cannot use the "Set Filter" option. Damien Cregan Hire an Expert
Can the new (2016) UI be implemented for old accounts?
Hi everyone, I have the old (pre-2016) interface on my account. Is there a way to enable the new UI for old (pre-2016) accounts or am I stuck with the current interface? I can't seem to find any button or link that enables it.
Help me create line chart
Hi. This is my database I want to make a chart like this to print out the process for each customer I have set the columns like this but nothing happened ! Pls help me. Thanks
SMS Twilio
How to use form field as part of text message, I am able send text message successfully, but I need the License_Expire_Date field as part of text. when use this script below the message does not go through, but replace the License_Expire_Date with sample text message it does work. Thankful for any help. This works var = input.Phone_Number.toString(); var1 = "+1" + var; //info var1; resp = twilio.sms.send("Driverlync",var1,"DL EXPIRED"); info resp
How can I set up auto refreshing time for other users in their views ?
I check forums but did not find browser auto refreshing time for added or changed data by forms. If a user submitted a form when other user can see this data in his view ?
Automatic Numeric Field Increase (without Auto Number)
Is it possible to have a field (numeric) automatically increase by a set "number", in this case just one (1) everyday without any input from a user and display it on the screen before the user edits/updates? I've search the forum and all topics for help with this and can't find anything. IE. ...... Day1 = Day1 +"1" if Day1 equaled "10" it would automatically update if I ran the scheduler or "WHATEVER" Zoho has to increase the number before it is displayed on the screen in onLoad. The field would
Please share your experience with the NEW UI
Hi Zoho Users, I'm a long time Creator user and I have been testing the new UI for a while now and I feel like 90% of the bugs have been fixed. However, based on my testing it seems that the new UI is about 2-3x slower! I love the new UI and and I'm willing to give up speed/performance for a more polished look. I'm curious if anyone else has seen the same results? Have you switched over the the new UI? If yes, do you have any issues? If not, what's holding you back? Thanks. Zalman
Customer Portal User change of email
Hi, I came across the following situation: one of my customer portal user changed his email address. This mean, I have to create a new user with his new email. The problem is that I want that he keeps access to the data he added with the previous one. Someone has had the same situation? Any help appreciated
Next Page