view an image or a file in a stateless form that is fetching data from another form.
Can this be done? I would like to be able to view an image or open a file that resides in another form in a stateless form.
search not allowing decimal entries
Form A has a lookup field <diameter> <diameter> is defined in Form B as as 3 decimal with max 10 digits when in view of Form A, and I search for a diameter with a decimal place, I get error "please enter valid number to search". but I can search for the decimal in FormB no problem. What is the cause? How to fix?
anyone know why this happens?
From the iPhone app, when loading information from a lookup field, it only shows the following, 1 option selected instead of showing the actual info in the field.
Seeking Help with autofill
Hello there, I'm new to zoho in general and I'm loving the service however, I am unsure how to go about something. I was wondering that if a user input their CRM name into a form that the creator would be able to fill out the rest of the form based off of that field alone. For instance, Joe Blogs has a quote, a purchase order and a sales order but doesn't want to have to type each out in the form. Would it be possible to just enter his name and grab that information from CRM. If this doesn't make
Copy form to new form
I have been trying to figure out a way to create a new form based on the completion on a previous form. Im creating a master manufacturing record. Once that form is filled it & saved I need to create a batch production record based on that info from the MMR each time I make a production run. The MMR includes a subform that is built while completing the MMR. For example it includes mfg steps. Some MMRs will have 5 steps while others have 12. This subform is built using the add new option to certain
How to set column formats in table chart view?
Hi there I have a table chart pivot report. I would like to be able to configure the format of data within each column. For instance, I have a date column and I have selected "Month and Year" but instead of showing "Mar 2014" it shows 201403. Similarly, I have a column showing Average. This is an average of currency so I would like to restrict that to showing 2 decimal places instead of default (12?) Thanks for your help
Filter a Lookup
I'm new to Zoho and have tried to do this ... https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup However, I'm getting an error - In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid Here is what I have build. 3 Forms Leases - Lease Name Tanks (multiple tanks per lease) + Lookup Lease Name - Tank ID Gauge Form + Lookup Lease Name + Lookup Tank (only want
Integration Zoho mail app shortcut with Zoho Creator sections
Dear all, My question is simple and short. As you can see in the attached image, I would like to know if there is any way to create shortcuts in the Zoho mail apps shortcut (in the left of the panel) with some sections of my Zoho Creator application. In my example, I would like under the Links shortcut to have Admin Functionality and Inventory setup shortcuts. If there is no way for that, then is it possible to have a shortcut under the Links with the name of my whole application?
Import form and subform data in zoho creator
Hello Situation There are two forms: Customer Account and Additional Contacts. Customer Account has a subform for additional contacts. However, the additional contacts were added separately before the subform was built. I need to connect up the additional contacts with the appropriate customer account. I have exported the data for both in separate excel sheets. Details The parent Account for a contact can be found by matching the "Ship To numbers" field.
Can I have 2 pop-up windows open at the same time?
I have a report, and I have a custom action that opens up another list, in a pop-up window. While that pop-up is open, can I use a 2nd custom action to open a form in another pop-up window? The only work-around I've come up with is to open a 2nd tab in the browser....
Fetch record in Subform with criteria
How to fetch record in Subform with criteria in script? I try same with fetch record in Form, but not working: x = From[ID = 0001]; for each x.Subform[Active == true] { } ---have error x = From[ID = 0001].Subform; for each x[Active == true] { } ---have error Criteria cannot be applied over fetch object
Data in form "A" not saving in form "B" in a nested IF/ ELSE statement
I have a customer service app (Form "A") that needs to save a date back to (customer_Info) form "B". The code is nested in a IF/ ELSE statement. The rest of the function works, but the updated date is not saving back to form "B". It is populated by the ID of form "B". ---> SiteInfo = Customer_Info [ID == input.Site_ID]; This section sends the email ok and with all of the info from form "B". It dose not save the date into form "B". What am I missing? // If the service is marked completed and the
Must be missing something
Have created a simple form. Data is organized by item number 01 to 99. I want to open the form view, & when a user enters an existing number into the item number field, I want to display in the form and have available to change the data associated with this item. Submit button at bottom. Not rocket science, I know but we all have to start somewhere. I have chased around help and forums and can see all sorts of good stuff but cannot get a handle on where to start with this simple function. Any pointers
esignatures
is there any way withint the zoho creator (or zoho writer) to add an esignature?
Allowing external access to just one data record - possible?
We have a membership database with about 750 records in Creator. We would like to enable members to access just their one record in order to make personal information updates. Is there a way to create a view that would allow a member to look up his/her information, and then make updates to just his/her record without having a Zoho account? When we talked with a Zoho pre-sales consultant, he assured us that we would be able to share direct links to records in order to do this, but we have not been
Email download link of uploaded file.
I want an email sent with the link to an uploaded file (say input.uploaded_file) to go out when form submission is completed. I see a several forum posts about this but none of the code suggested seems to work, seems like code is outdated. Can some one please suggest what I put in the Sendmail funtion to create a link for the uploaded file so the person can download the file.
URL link for uploaded file v. download link
Is there a way to link directly to an uploaded file via a standard URL that allows the email/browser app to handle the file accordingly. For example: http://creator.zoho.com/zoho.adminuser/zoho.appname/FILES/uploaded_file.pdf I don't know what path 'FILES' would be? versus: http://creator.zoho.com/DownloadFile.do?filepath=/input.File_Upload_1&sharedBy=zoho.adminuser&appLinkName=zoho.appname&viewLinkName=yourViewName The form scheduler option to send attachments with emails is limited to 100 per
File download url
Dear Users, Creator support uploading of files through the file upload field in the form. Once a file is uploaded, you can download that file through the view. And each file download link in the view will look like the one below http://creator.zoho.com/DownloadFile.do?filepath=/1248931841640_dsc00007.txt&sharedBy=user1&appLinkName=SampleApp&viewLinkName=Sample_View The url contains file id (filepath), user name, application link name (appLinkName) and view link name (viewLinkName). We had certain
Rest api access of zoho creator
I have a free account on Zoho creator. I have one form developed in creator. When I am trying to add record through rest api access, I am getting redirecting to Zoho home page. My rest url is - https://creator.zoho.com/api/skagrawal10/xml/copy-of-mtech-database/form/registration/record/add/ Post Parameters are authtoken scope NAME Please guide me in this.
Autonumber field cannot be used in the formula field?
Tech support told me that Autonumber field cannot be used in the formula field. However, my formula field was working fine with autonumber. Did they change the change the setting? My formula field is very simple. It shows "Last Name - autonumber." ex) Smith - null Of course, it shows "Last Name - null" when I save the record. But, when I edit the record, it surely showed "Last Name - autonumber." ex) Smith - 5930 I wonder why thousands of records were working fine, and it stopped working recently.
disable field on edit
Hello. Is there a way to disable a field on edit if it has data in it using script? Example: I have a service ticket for my field techs. One guy will add a record, then another will edit and add more data. I'm looking for a way to prevent the second guy from deleting data from the first guy. Each guy opens and edits the record multiple times so just can't disable on edit...only if data is there is what I need. Thanks
How to change message Invalid entries found??
Hello, Changing the message to my language Português Brasil? Invalid entries found. Please correct and submit again. TKS...
Calculation on a page
I need to calc this on a page Table: EntradasRomaneio Sum Field: Valor Grouped by Field: Contas_Banco I want to show the sum of Valor field grouped by Contas_Banco field in EntradasRomaneio Table
Place to write common business logic using multiple forms in Zoho Creator.
Hi, I am trying to write some business logic that involves multiple forms in Zoho Creator. I tried with functions but it does not allow to provide input /set a value from/to a form through a function. Sample code is mentioned below. int test.test() { input.Trainer_s_work_details.Number_Of_Account_Opened = Beneficiary[((Trainer == input. Trainer_s_work_details.Trainer && Bank_Account_Opening_Date >= input. Trainer_s_work_details .From_Date) && Bank_Account_Opening_Date <= input. Trainer_s_work_details
New to Creator
So we have an app, call it App A. Inside of App A we have 2 forms/tables. The first is more of a data form that our customers will fill out. The second is a form we will use in house to manage/track the project. The first field in the data form is *Project Name. Once the data from is submitted by our customer we would like to have this field *Project Name also appear as the first field in our back end form/table. What is the best way to do this? Would it make more sense to use a subform? Hope
Specified Duration in Success Message Issue
When adding a success message, I noted a new option to specify a duration. I assumed it was in seconds. But the value seems to be ignored. Is this a beta-feature? John M. Whitney
Creator Support No Answer
Is it just me or has anyone else had issues contacting Zoho Support via phone? it seems like every time i call it goes straight to a Voice Mail.
is it possible to change form design at run time?
I want add or remove button, or field at run time. meaning change the current form design. is it possible? thank you
Adding record into form with lookup field (by custom action function)
I created a function to load a new record with data from one row of a report. The form I'm trying to add a record into uses a lookup field (integer). The lookup field is mandatory. When I execute the function, I get an error: "Reference field unit_code not having the value 465,202" (the 465202 is the integer I'm trying to enter into this field, but the error is showing it with a comma, could this be the problem?) Must a lookup field always be entered by hand?
Zoho creator generated Emails are not longer received at Gmail and at Yahoo accounts
Hi, We have a form when upon new record additions an email is generated to recipients at Gmail and Yahoo. This used to work as of 3 months ago and has now stopped working. The intended recipients are complaining that they no longer get these zohocreated emails. After spending some time on phone with Zoho support and experimenting I narrowed this down to the fact that Gmail and Yahoo are not delivering these emails. An email box hosted on hostmonster however is receiving below. So it seems Gmail/Yahoo
replace date field datepicker with Calendar view?
I'm developing a job tracking application. There is a form, Jobs, that tracks each new customer job. Within that form, there is a subform for entering appointments with a client for estimates, jobs, etc. There can be more than one appointment for a job. The subform, events, has the basics for scheduling an event (event name, start datetime, end datetime, etc). I also have a calendar view of the events form. The event form is basically a schedule of all past and upcoming meetings with clients. When
Enforce Lowercase
I have an application set to only allow unique emails. However, I noticed that the same two emails can be registered as long as the upper/lowercase character are not the same. Is there a way to convert a string to all lowercase?
Can I show a related field in a form, without having a field for it?
Can I fetch and display the value of a field from a related form, without actually having to have a field to hold the data? This would be in On Edit, On Load example: fetchPerson[ID == input.person]; show fetchPerson.Email;
How Can I iterate through Radio Buttons
I have a Form with a number of Radio Buttons. I want to create a drop down list in a second Form based on the values of all the Radio Buttons (their names, I guess) whether or not they are selected. Bruce "Speedy G" Peaslee The World's Fastest Programmer
Pie Chart from a Formula Field?
How can a pie chart be created to show the percent of On Time Quotes vs Late Quotes? Form Fields Due Date Sent Date Formula Field On Time / Late if((Quote_Due_Date >= Quote_Sent_Date),"1","2") Thank you in advance
Formula
I need to use this formula but the formula field does not calculate this in the correct way ex. (Lunch_Number_3_5 *Serving_Amount_3_51) + (Lunch_Number_6_12 * Serving_Amount_6_121) (10*1.5)+(1*2) = 17 but this is not what Im getting. Im getting 32. Any help Thank you
Error Message with the "Delete Duplicate Records" Code
This is what I was told to put in to find duplicate entries in a a data base and delete. But when I do I get an error message. myList = list(); duplicateRecordIDList = list(); for each record in myForm [ID != 0] { if ( myList.contains (record.Email) ) { duplicateRecordIDList.add(record.ID); } else { myList.add(record.Email); } } delete from myForm [ID in duplicateRecordIDList ]; This is the error message Error at line number : 1 Improper Statement Error might be due to missing ';'
Fetch records
Hello, I need to set a report criteria based on a form from a different application, Is this possible? And also, how can I fetch a lookup field by its ID? Thanks.
Creator API Rest access is redirecting. No error codes are shown just showing Moved permanantly
I am calling rest api to add a record with authtoken, scope and NAME field in post request. But it is not showing any error codes but redirecting to zoho home page. I have free account. https://creator.zoho.com/api/skagrawal10/xml/copy-of-mtech-database/form/registration/record/add/
HTML View help
Hello all In my application I am trying to create a HTML view that allows me to capture details for my workers. The code is attached below: htmlpage Tankkarte_Details(ID) displayname = "Tankkarte Details" print = true pdf = true content <%{ Mitarbeiter = Personalien [ID == input.ID.toLong()];%> <strong> Mitarbeiter</strong>: <u><%=Mitarbeiter.Name%> <%=Mitarbeiter.Vorname%></u><%if (Mitarbeiter.ID == input.ID.toLong()) {%>
Next Page