Re Old Fields Value for Subform
Hi When in a form with the form of Edit mode, how to know whether a subform data is updated, is there any like normal form, there is a validation of Old Fields Value? Or could you please guide me how to know the subform data has been changed. Thanks Stanley Guo
Zoho Creator Form Captcha Not Working on iPad
Hi We have had several users complaining that the following embedded form Captcha does not work an iPad: http://www.rentlondonflat.com/property-application We have tested this and can confirm the Captcha does not seem to be accepted on an iPad. But same form works on laptop or Samsung Pad. So error seems specific to an iPad. Please advise. Thanks
SubForm Fields in Email?
I am trying to populate parts of an email with fields from a subform. I am triggering the email with the subform field's On User Input action in the parent form. When in the email builder I select the desired field from the subform collection presented in the Input Fields tab. In the email it looks like this <%=SubForm.SubForm_Item%> However when I try to save the email script I get the following: Error at line :1 Variable 'SubForm' is not declared Any ideas?
Updating consecutive records
Dear Zoho Creator team, when one updates consecutive records, it's very helpful to have the screen remain in place, showing the line just updated - instead of (the current default of) going back to the 1st record on page, and wasting time trying to find where you were. on top of that, since Ctrl + Home/ Ctrl + End already brings the user to the top/ bottom of the page (respectively), it makes more sense to have the default being "stay where you are". hope to see it soon at work, thanks, Anat
Chart Based on View Request
@ejaffarian We have come up with an option to create Pivot Table & Pivot Chart based on a View like our old app builder and it is available in creator.zoho.com now. You can try this option via "Create New" -> "Report" -> "Pivot Table or Chart" -> Choose Form and its View to create one please check the same. @Others Please note this option will be enabled for certain users alone (on request basis). Thank you, Saran Please enable that for user sigroup
Bulk edit doesn't run script
Hi Zoho team, I'm trying to have the age of employees get updated once in a while w/out having to update them one by one. For some unexplained reason, when i use bulk edit to update these records, script On Edit doesn't run. Of course, i've checked that my code is working for single record updates - no problem there. is there a workaround for this issue? is the Zoho team working on fixing this bug? thanks, Anat
Add Record to a Dynamic Table Name
I have a variable set that is a table name and it can one of many tables with the same layouts. Is there a way to use a variable for the table name in an insert? insert into Variable_Table_Name [ Added_User = zoho.loginuser Customers = input.Customers Marketing_Manager = input.Marketing_Manager Project = input.Project Service = input.ID ];
How do I get a field to be required once someone enters any data into a date field?
In my form I have a "Document Date" field, when someone enters any date in that field, I want the field "Upload file" to show and be required. Here is the script I wrote for a similar one but the field Filling_State = to PA. I just want any date entered to trigger a similar action. if (input.Filing_State == "Pennsylvania") { show Date_Estimate_Filed; show Date_Estimate_Filled; show Estimated_Filing_Amount; show Proof_of_Payment_Due; show Proof_of_Payment_Filed; } else {
Julian Date?
Is the Julian Date format supported by zoho creator? I cannot find documentation on how to call it.
Dynamic Display of fields in Record Summary View
Hello, I'd like to know if it's possible, and if so how to, create a record summary view which allows for fields to be displayed dynamically based on conditionals. For example, if I have a field for Extraction= (No_Extraction), (In_Progress), or (Extraction_Complete), and a checklist of extraction-related tasks, then I'd like to do the following: (1) if Extraction == No_Extraction display "No Extraction Planned" display Service_Plan (2) if Extraction == In_Progress display a 'Removal Progress' section
Vertical Divider in 'Record Summary View' Section
Hello, Is there a way to add vertical dividers between the columns of a Section in a Record Summary View? Thanks, Elizabeth
how install date in native language?
hi in my creator's app there is date field how can i change it from "31-October-13 12:30:28" to "31-октябрь-13 12:30:28" name of month change from english to russian?
Lookup Box Dependency Filters not working.
I submitted this directly to support 3 days ago but as I've not received a response, I thought I would try the open forum. First I'm a creator newby, but none the less... I'm trying to filter a lookup field based on another lookup field on the same form and I'm trying to use the instructions found here as guidance. I have three forms which are created as a basis for each of my lookups for my final input form. However for this discussion I will only discuss two input forms and the final data collection
Embed Audio in URL Field -
I am trying to play a audio file in a zoho view -This works If I do it manually this is the final URL I need in the URL field data:text/html,<audio src="http://mysite.com/admin/recordings.php?recording_id=127" controls> I am using a CURL to add data to creator myURL = ("http://mysite.com/admin/recordings.php?recording_id=") + input.recID2; // I use this to pass recording ID in input.link = myURL; // If I post this into a single box it adds the correct URL myURL2
Can't get form to autopopulate
I need to populate a vendor form from fields in a client form. I have a dropdown field that I've populated with First Name and Last Name fields from the client form, but I'm not sure of the syntax for the, "on user input" function that will populate the rest of the vendor form. Here is what I have so far from your examples: if (Voucher_Clients[First_Name Last_Name == input.Select_Client_Name].count() > 0) { temp = Voucher_Clients [First_Name Last_Name == input.Select_Client_Name];
did not changes name of field
working app try change field name in dashboard name changes but in app it still previous how to make changing name of field?
Word Count in Multiline NOT working :(
Hello all.... I have the following script to stop a user from submitting a narration text to us that is above 125 words. However, for some reason, the submission does not get cancelled... wordsList=input.narration.toList(" "); wordsCount=wordsList.size(); if(wordsCount > 125) { alert ("Sorry. Only 125 Words or less are allowed. Please correct your narration text accordingly. Thank you."); cancel submit; } Thank you very much. Francois
Use <%=formdata%> on delete
The variable <%=formdata%> can be used in the On Edit->On Success section. It shows all the information on the form. It would be very helpful to use this On Delete. That will make it easy to email all the details of the record when it is deleted. This provides protection in case the wrong record was deleted.
ONLY DE ID...
I want a form to give me the value of an Id in a lookup field from a form wwith the structure IdX (Num) - X (Text) the "view" view. Ex: I select the value X in a lookup field (that has an Id, Ex: 1). I want the form to give me just the Id. I did a form that gives the "1-X", I want only de id...
Users cannot access shared applications on Zoho Creator
Currently none of my users can access the applications I shared with them on Zoho Creator. Can you please inform what is going on? Also, support phone lines are stating there's no representative available for Zoho Creator.
Can't set up lookup criteria using Deluge script
I've now discovered I can access Lookup fields (they appear as Forms - e.g. the Publication lookup shows up in the dropdown box with all the fields within the Publication form). Nevertheless, I prefer using Deluge script. This GUI version slows me down.
Recover Field Content Using API
I want to recover a field from an application form to use in another website as a java variable. Trying to use the REST API to GET values, but with no success. Can anybody help? If there's a simple way that I'm missing, then I apologise in advance :-)
Lookup fields display does not make sense
in my form I have several Lookup drop downs. Each one contains a code # for a part option and the purpose is to build a complete part number made up of all the individual options chosen. Each option table has 2 fields, Part# and Description, for example One of the Tables may have Part # Q36t , Q39t, G34d etc are in a part numbers Fields and Heater Option36W, Black Paint Option, and Steel Option. I appreciate the feature of being able to associate the 2 fields in the Display Fields so that when I
One Click commission
Does anyone know which is the difference between "Quota" and "Annual Quota" in "OneClick commission Tracker"? It looks to be something confused. Thank you Matteo
How to segment fields
Hello everyone, Do you know if I may segment fields on my app page so that I get a clean presentation when I log onto my app page. Basically I would like to have the following display: GENERALITIES (as to the title) 1) 2) 3) DEPARTMENTS 1) 2) 3) 4) Indeed, I need to allocate those information to each title. I tried using the GROUPING/SORTING option of zoho creator but I don't get the desired display. Thanks for your reply
Sharing issue
I realized this is trivial, but i haven't been able to figure it out. Probably my inexperience. I am trying to share portions of my app with two individuals. I have shared it and sent the email notifications but neither one has received the email. Anyone have a solution? Thanks for helping the newbie.
How to embed an uploaded css file in an HTML view?
How can I use an uploaded CSS file in my HTML views? I've tried two different ways, but neither seems to work: <link rel="stylesheet" media="screen" type="text/css" href="https://creatorexport.zoho.com/DownloadFile.do?filepath=/[blablabla].css&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>x&viewLinkName=Supporting_files_View" /> and <style media="screen" type="text/css" src="https://creatorexport.zoho.com/DownloadFile.do?filepath=/[blablabla].css&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=Supporting_files_View"></style>
Clarification on ways of displaying content in Pages
I want to check my understanding of the use of pages. Can someone confirm I have this right, or correct my misunderstanding, please? To display Zoho data in a "page, there are three ways: 1. Use a "div" statement 2. Use an iframe - With the URL explicitly included - With the URL generated by a call to OpenURL 3. Embed fields explicitly within the page Am I right in thinking that, when using a "div", you cannot perform any filtering on what gets displayed. For example, if I want to display a single
Hiding Tabs for Certain Users
Is there a way to hide tabs based on the logged in user? In my application there are three tabs. I want to have the "request" user to see only the first tab. While the "manage" user sees all three tabs. Possible?
Need to Sync between CRM records and Creator records
Hi Everyone, I need to make an automated flow which can make a sync between CRM and Creator records. If i update a record in CRM then it should change the creator record automatically and vice- versa Half of task is done by me, if i do anything in Creator then its reflecting in CRM as well whether its creating new record or updating existing record. Also when i create a new record in CRM, same record is being created in Creator form but if i update existing record in CRM then i am not able to update
Track users
I have an app that I share with 2 other people. Is it possible to track their activities? Would it be possible to tell which user did or didn't make an update or change to our data?
Using Record ID to autopopulate
Is it possible to use Record ID from one app to autopopulate (certain) fields in another app? I'm using forms to set up a workflow, so as a form is submitted, an email with the appropriate info is generated to a second group. That group picks and chooses which sets of data to take action on (3/10). The info from the first form is needed, along with new info that the second group adds. Want to remove the need to retype (mistakes+extra effort) all data and use the record ID to pull data from first
Dealing with & in URL parameters
I am dynamically creating URLs to display filtered views of tables based on some table values. When those table values are strings that contain the & character, the search does not work because the & is taken to be a parameter separator. e.g. /view-perma/Contacts_List?Org_Site=B&M%20Services doesn't find any results. But if i replace & with it's ascii value, and use /view-perma/Contacts_List?Org_Site=B%26M%20Waste%20Services-Cheshire that works fine. Now, I COULD write some code to do that replacement
Basic Question on Creator layout. Cannot see the tabs
I have a silly question. I have not used Zoho creator for a few years and cannot figure out how to get my layout to show the tabs as shown in the tutorials and videos that I see. I do not have a tab for Views or Share... This is the layout that I see in the tutorials and videos and remember from the past. My Layout looks like this.... Please could someone tell me how to get the normal layout view?
how do i submit zoho forms to android market? can i change it to apk format?
how do i submit zoho forms to android market? can i change it to apk format?
Sharing forms in a section
Hi, I have numerous forms that I organised by building them into pages, and then putting the pages into sections e.g.: Section 1 --->Page 1.1 (with Form 1, Form 2, Form 3) --->Page 1.2 (with Form 1, Form 2, Form 3) Section 2 --->Page 2.1 (with Form 1, Form 2, Form 3) --->Page 2.2 (with Form 1, Form 2, Form 3) I use Deluge to share specific sections with invited users, but when the users log in, they cannot access the forms on the pages. Also, there doesn't seem to be a way to share pages, just sections
Set variable not working in the custom button of stateless form
User Name: kumar.n Application URL: https://creator.zoho.com/appbuilder/kumar.n/reportissue Access To Support: Granted -Neeraj.
Database Questions
I am a real estate agent in VA. I have created a form, allowing me or another agent to enter in several fields to capture information on incoming leads/prospects, then save that record to a database. I have 5 buyer agents working for me. Now I want to be able to assign a buyer's agent with a particular lead(s), so when they log in they only see the leads assigned to them, and no one else. I have created a drop down box with each of their names in it, and this drop down box is only viewable
How do you convert number to string?
For my Products I would like to create a new SKU which consists of several Single Line fields and the Auto_Number field. When I try the following: input.SKU = input.Auto_Number; I get the following error: "Variable 'Indd_File_Name' is already defined of datatype 'STRING' but trying to update 'BIGINT' datatype" When I try input.Indd_File_Name = input.Auto_Number.toString; I get Invalid collection object found But it also won't let me put String values into a Number field: E.g. when I try: input.Number
Persistant Problems with ZC Groups
1. I cannot delete a member from a group: I'm the account owner! 2. I cannot add one of my domain users to a group. In fact, it shows none of my users!
Next Page