Consolidation of stock tables
Hi! I am new to Zoho Creators. I am having 5 different tables for stock count. For example: Table 1: Chennai Stock Table Table 2: Delhi Stock Table Product Model Stock Count Product Model Stock Count A 10 B 20 C 20 C 30 Simillarly, there are 3 more tables for different locations. I want t consolidate all
No duplicate values in two or more forms within the same application
Hi... I need a little help. I have an application with more forms inside. I would like that a field become unique in every form (i don't want that a student duplicate a value). For exanple: A student must book for an activity for the days 6 and 7 May but he can't book himsle for the days 10 and 12 May because he already booked for the days 6 and 7. Ho can i coul do it ? Thank you in advance for every suggestion.
Htlm View showing upload or not links from differents views
Hi, I have a HTML view that summarize datas and uploads from some views as: myAnswer = FormA [ID == input.recId.toLong()]; myAnswer1 = FormB [FieldUnique == myAnswer.FieldUnique.toLong()]; myAnswer2 = FormC [FieldUnique == myAnswer.FieldUnique.toLong()]; So when I want to put a download link in the HTML View I write this code: <td NOWRAP> <a href="https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=myAnswer.UploadField%>&sharedBy=IM&appLinkName=NAMEAPP&viewLinkName=NAMEVIEWFORMB"><%=tempVariable%></a></td>
Creator App - iPad / iPhone Issues
I have a lookup field (Lookup A) that fetches data and updates other fields in my form. One of the fields updated is a another lookup field (Lookup B). Lookup B then updates other fields. Problem 1 - Using the Zoho Creator app, this works on my iPhone - However - it does not show the data in "Lookup B"...instead it says "1 option selected" - How do I get it to show the value of Lookup B? Problem 2 Creator App on iPad - Lookup B is not updated Problem 3 Using Creator App on IPad - Pictures are
Creator Data WIll Not Import Into Zoho Reports
I am no longer able to import Creator data into Zoho Reports. Steps to recreate: Creator - Data Location = web, in the URL box I am inserting the URL from Creator "links" "permalink", "publish URL". It returns a message "unknown host or host not reachable. Please verify the URL provided"
Submit Failure Message when Press enter
I have a form that will get data from zoho crm. My problem is when press enter, it will show the error message, All i need is to disappear that message only, if (input.Email != "") { vSearch = "(Email|=|" + input.Email + ")"; crmRes = zoho.crm.searchRecords("Contacts", vSearch, 1, 1); if (crmRes.size() > 0) { fa = crmRes.get(0); input.FranchiseApplicantsID = fa.get("CONTACTID"); input.First_Name = fa.get("First Name"); input.Last_Name = fa.get("Last
Pricing zoho creator
Hello, I used the free version of Creator Zoho, now I require buy 1 user, when revenue in my account the standard plan is $ US25 for 5 users, but if I enter a new user the standard plan is $ US5 for 1 user, I need only 1 user, I can buy it? Julian Calderón Escobar,
Lookup Link Records with Pivot Tables/Charts
We have a table of sales data (A) which link to a table of product data (B) via a Lookup from A accessing a unique product ID in B. How can I access parent fields in B while running reports for A? This help document shows how to do this for List reports under the header "Creating a Link to Parent Records":https://www.zoho.com/creator/help/forms/creating-relationship.html But how do we do this with Pivot Tables & Pivot Charts?
Remove Commas on a Number field
Some of the user put commas, when they put commas, The formula field is when wrong, How can remove commas automatically on input?
Ratings
I am working on an application that I want users to be able to rate records (out of 10) in. I have created the fields for it, however, I am having trouble figuring out a way to display the average ratings. Right now, when a user rates a record, the view just creates a copy of the original, with the new rating. Could someone explain how I can get the average, without creating extra records?
Alert based on calculated time
Hi, I write to support but have no answer to my problem. I have a script to show an alert based on calculated time (lookup field of meeting) "on input" of field. Now, with Creator update, I try the same script in other form but don't run. Anyone have similar problem with? Thanks in advance. Mike if (input.lookup.toString() != "-Select-") { meetTime = FormMeetingPlace [PlaceMeeting == input.lookup.toString()]; timeDiffinMilliseconds = (meetTime.StartTimePlaceMeeting - zoho.currenttime);
Zoho Creator Form Builder is inaccessible to some users
Form Builder is not accessible through key commands or a screen reader (only through dragging with the mouse). Our users with visual disabilities and limited dexterity are not able to use the service.
Cannot edit records
Users of my application are unable to edit any records. I have logged a support request and need someone to contact me immediately
Autopopulate value in sub-form
Hi, I have a main form with sub-form that fetches another form. Sub-form has product related fields. What I want to do here is, based on the selected product(From CRM Module) I want to fetch its related price to a field. But it is not working as I expected. If my lookup field for product is within creator I dont find any issue. If I want to get the product from zoho crm I am not able to auto-populate unit price field.I don't know what I am missing. Help me sort out this issue Here is my code, [Products->On
Backup Failure
We set up Sales Management 4.0 for testing purposes, and we're getting failures when trying to create a backup of the app. Is there missing data we don't happen to see?
No access even after sharing
How come when I shared my app to my friend, he get's "You are not allowed to access this application." message even after he clicked on the link that came in his inivte mail? I have shared the application with him.
File upload does not appear in record
I created a form with a file upload field and in the form I can upload the file but when I view the record in the report view the field is missing. What am I missing or what am I doing wrong? Is there a place in the properties of the file upload field that I don't enabled or modified properly?
user roles can be assigned only after approval of Manager
hi, if admin assigned roles to user , mail goes to manager and if manager approve then only respected role assigned to user.. it is possible,if yes how?
MS Access Migration issue
I have used the migration tool to migrate a small database from access to zoho. Each time I try I get a pop up that the migration was successful, but when I go to my account on zoho it is not there. Is there something else I need to do? I have tried waiting a whole day and checking back, but it is still not there. Thank you , Matt Holtzclaw
Date field, how can i limit a value up to 30 days?
When i enter a date, how can i set limitation til 30 days? The date purchase will not exceed to 30 days, if exceed, it will pop a alert? I just need the If Statement for this, hope you guys can help me
Invited new users being put into "trial" accounts that have no ability to access shared applications
Help! Starting today, my invitations to new Zoho users with whom I have shared my applications can no longer access them. They never see the "dashboard" screen - only the screen that prompts them to start creating their first application. They have to "upgrade" to a paid subscription in order to see my shared applications. I am supposed to have unlimited users on my subscription. Please advise ASAP!
checkbox to show/hide fields
I figured out how to have a field hide/show when a specific radial button is clicked. But I can't figure out how to get specific fields to show when specific check boxes are selected. Can someone help me with this?
Execution Failed
Hi, I'm getting an Execution Failed error when trying to execute a Scheduled Report. Execution Failed Error details Error in executing ... (Custom Schedule) Error. Error in executing Send Mail Task Please advise on what should be done.
Execute Script Error
Hi, I'm getting an error when trying to execute a test report. I've attached the error. Thanks, Jon
How to get GetURL variable and pass it to another form?
I have a form that is filtered using a url variable. Example: ..//#Form:Income?invoice=123 When I click the "make payment" button from mu invoice page. The user will be redirected to another payment page and the payment page will inherit the selected invoice ID (in this case is 123). How should I code this in my "make payment" page?
Using my own domain to display pages
Can some please direct me to information or explain if there is a way to display a "HTML Page" under mydomain.com/ Thanks
Open URL function and invoking "on user input"
I have a view with buttons next to each record. When you press the button, a form opens up and a couple lookup fields are populated. Then the "on user input" action are invoked and additional fields are populated. I made one change...instead of open "popup" now I open in "same window" and the "on user input actions are no longer invoked. It appears that opening a "popup" and pre-populating fields will invoke "on user input" actions for those fields that are populated, however, when opening in
Issue in assigning the value to a field on User Input
I try to create the Sales Order form in creator. I've created two forms named "Order Form" & "Order Line Item". "Order Form" has the sub form "Order Line Item". In "Order Line Item" form, I've two fields named "Products" & "Unit Price". "Products" is zoho CRM field for Products module & "Unit Price" is float type. I tried to assign the "Unit Price" while selecting "Products". I wrote the following script on Field Actions --> Products --> On User Input Script: row.Unit_Price = 10000.0; When I running
Include Parent Table Fields in DropDown Form
I know there must be an easy answer to this: I have 3 tables with the following fields: Customers - Fields(First_Name, Last_Name, Phone) Jobs - Fields(CustomerID, Job Name) Billings - Fields(JobID, BillingAmount) The relationships are one customer to many jobs and one job to many billings. When I enter a billing entry, there is a dropdown for Jobs to select the JobID and the values that can be shown are limited to the fields in the Jobs table. Is there a way to include fields from
Make hidden fields "required"
Hi I would like to make a hidden field "required", but only when it is visible (the field is visible when a specific value is selected in adropdown. Can this be done? BR Skouboe
How to get GetURL variable and pass it to another form?
I have a form that is filtered using a url variable. Example: ..//#Form:Income?invoice=123 When I click the "make payment" button from mu invoice page. The user will be redirected to another payment page and the payment page will inherit the selected invoice ID (in this case is 123). How should I code this in my "make payment" page?
Email notification
Hi I have an online form which, when submitted, sends an email notification to specified people when certain fields are populated. When those fields are not populated, it still enters the details on the calendar view, which is fine, that's how I want it to be. However, now, all of a sudden, ALL submitted forms are being emailed, regardless of whether or not those fields are populated. I have changed nothing in the settings so why is this suddenly happening? It's so annoying when you change things
Easy way to remove Microsoft Word formatting from rich text fields?
When I export my data from Creator into Excel, I notice that the rich text form fields contain a lot of unnecessary Microsoft Word formatting code embedded - such as... <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility>
Linking ZOHO Creator to ZOHO Reports -can we link Creator to ZOHO Reports?
We have been using ZOHO Reports extensively for the past two years. We are thinking about using ZOHO Creator to create forms so employees can update the data in ZOHO Reports directly from Creator forms. Is this possible? I am seeing that we can import CSV/XLS and Access data but I have not found anywhere that states we can link a new Creator form to an existing ZOHO Reports databases. Is it possible? Also using Creator forms can we add, edit, and delete data from ZOHO Reports? Michael Kokernak
Customer Portal
My agency has multiple applications that team members need to access. How do they get access to all six at the same time as opposed to having to enter multiple portals separately? We have granted them permission to use all applications and sent out email invites. Now each of them has several usernames and have been required to set passwords for each portal. Most of them don't work and now everyone's confused yet few people have access. How best to proceed with this? Also, we have deleted some applications
Restore Data
Hi Zoho team, Can someone please assist to restore the deleted records? I accidentally deleted records which have "Date Filed" for April. Appreciate if someone can help immediately please. Regards, Maricar
Zoho creator on mobile site
Hi. Can anyone tell me why the mobile version of the form loads with the drop down lookup fields like this and if there is a fix for this?
Close a form on submit
Is there are way to close a form on submit? What code do I need to put on "On-Success"?
Fetch data from another app and use in a formula
Hi, I have a app named "skills". I also have a app named "age". At least I have a app named "pointer". In pointer I made two lookups.One from app Skills and another from app Age. What I need is make a formula who combine the field value "specialist" in Skills, the field value "age" and combine in a formula in pointer - input.profile = input.skills + "" + "\" + " " + input.age. The input.skills are from app skills. The other is from another app. I can't use the default value for the fields (the
How to use Map() and postURL()
I have read the ZOHO Creator help guide and attempted to make a form post to an external application and failed miserably. I think it's me not being calibrated on how all the parts fit together. For the reference, the api is from SmarterMail . I'm just going to be lazy and post the form info below and hope someone with a better brain can help The form target to post to is http://xxxxxxxxxx.org/Services/svcMailListAdmin.asmx/AddSubscriber The form fields are all text: AuthUserName AuthPassword DomainName
Next Page