Confirmation email with data from lookup fields
Currently when a confirmation email is sent any lookup fields show the record ID. Normally I would just add a send mail in the On Success section after fetching the record. However the Confirmation email can include a PDF attachment of a form Template/Record Summary. Is there a way to fetch a record in the Send Mail notification section or Is there a way to include a PDF of a Template/Record Summary.
Formula Field..
Asking for youre help. How can i do this? If date feild is Not null, it will not count the data and turn it to 0. please see picture
Is this possible customize view?
Hope you can answer me
Barcode Integration
Hi, I saw on the forum that Zoho Creator does not support barcode integration. If I had an excel file with barcode information and imported it into Zoho, is there a way to access a barcode number from a form (to be an ID for a product that I have information to fill in in the form)? I'd appreciate any direction on how to get barcode information into Zoho creator. Thanks!
Email Builder: Insert Expression Broken
Similar to https://help.zoho.com/portal/en/community/topic/html-builder-insert-expression-broken Now inserting an expression into the email builder fails. You only get what's shown in the picture and the "X" does nothing to close the window. You have to refresh the whole page to get out of this. Cheers, John Whitney
HTML Builder: Insert Expression Broken
Attempting to insert an expression in some HTML only gives this: ...in Chrome, Safari, and IE Cheers, John Whitney
Private URL Link and Application Portability
My client's application has a mixture of public and private sections. Some of the forms will be placed in iframes on hml pages shared using the private url option (share without a login). When I finally export this app and hand it over to my client, all the private url links will break. It would be nice to have a deluge function that takes care of this like: https://creator.zoho.com/<%=zoho.adminuser%>/<%=zoho.appname%>/form-perma/user_form/<%=zoho.privatekey%> Is this even possible? Cheers, John
Convert Zoho Creator App Into Smart Phone App
Can a Zoho Creator App be converted into a smartphone app?
OpenUrl vs insert into
As far as I can see, there are 2 ways to create a new record: 1) Use openUrl... and pass all the field values as "&fieldname=" + fieldvalue... The disadvantage is the string nature of the field names which don't get updated if a name is changed in the form. 2) Use insert into... and set all the field values and then open the form for editing using the openUrl 'record-edit' format. The advantage is that all field names will be updated if changed but I guess because the form name is a string, the form
Linking form with calender
I amnew to creator! Have created a booking form which I will embed in a website. The booking form has a date field and I need to link the date field to a calnder so each of my customers can see the bookings they have made on a day to day basis, without seeing bookings by other customers bookings. Can this be done and if so some help would be very much appreciated.
Paypal - cancel payment
Hi - I have a form linked to paypal and everything works if you go through with the paypal process. But if you submit the form, and at the paypal screen change your mind and cancel - I get a "Payment has been cancelled" in a little zoho status window, and then at the main creator.zoho.com page - it doesn't go back to my site. Any ideas how to handle cancelled payments? This is not a subscription - just cancelling a one-time payment before it's submitted. Thanks,
Search criteria in mobile app
I have a DB with approx 18,000 records of names and address's. When I view a report on the iphone mobile app and I put in a search criteria the results I get are just the first 50 records repeting over and over. For example .. I have a field called SN (street name). whan I bring up report on monile app I can scroll down and see many records. When I search on the field SN = Main St it returns the first 50 address's on main street and stops. when I scroll down it brings down another 50 address's
scheduling email for record with certain criteria
So if I had a bunch of records with say 3 fields Email address Message to send send email y or n so say there are 100 records I want to send the "message to send" to the "email address" once every 3 hours if the send email field says "y" Could someone explain the logic please
Application Context (Again)
So in testing out my clients application, everything is within the application context EXCEPT for the confirmation email for the newly created zoho account. In this email, you get a link that opens this page: I'd like to see the links for "HomeBlogsForumsFAQ" removed as it will confuse customers. Additionally, the zoho logo should be the admin's logo. Once you click that "Continue to Sign In", I'd expect as a customer to see the application. Instead you get this: This is not acceptable. I understand
Questions about limits ...
@ZOHO Creator Team: A couple of questions about limits. Over here ... https://creator.zoho.com/platform/home/settings ... it says that ... 1) Maximum number of executable statements per deluge action (e.g. on load or validate or on submit ) is 5000 When you compose an HTML View, do the commands constitute a deluge action ? 2) the number of times you can post data to another website per day is 500 Is there any limit on the number of API calls that can be made from external applications ? Gaev
eliminate sign-in on form on my website
I have attached a form on my website and I don't want to have parents sign in with email and password to get into the fill form data sheet. Can I also get an email sent to me when a form has been submitted? Sean
Field don't update
Hello, On load I write a command to fetch record with form: https://creator.zoho.com/appbuilder/misca/consulado-geral-do-brasil/form/CI_Confirma_o_Retirada_Passaporte/edit but the record in the field "Missao" don't update! Thanks Mike
Help for report , i got the message : we are unable to fetch this data sorry .....
Listing des personnes par évenements : We are unable to fetch this data, sorry! Please note that your data is SAFE.Reporet this problem to support@zohocreator.com
Will Payment form (Paypal) preserve lookup parameter?
I have a customerID being passed to a payment form. On submit, the page is redirected to Paypal; once payment is posted the Paypal page is supposed to return to Creator. Will that customerID be preserved upon the page-return, or will the lookup value be empty?
Make OutBound Call to Google calender so need IP address of ZOHO
am making an small application called as event scheduling. For that i am using zoho pages. and from this zoho page i am making call to Google Calendar, but after getting Access Token, and Refresh Token from Google i want to use API Call for that Google Needs IP Address of ZOHO Creator Server. i.e. Actually i want to make outbound call from zoho to Google Calendar so for that i need IP Address of ZOHO Creator Server. if any one know this please share it with me, Thanks in Advance
My attempt at a Audit Trail Log. Fully Working + a Few Question for ZOHO Employees.
First part of the post is a script for an Audit Trail, feel free to copy it if you want. Second part, are questions i have for some advanced user or employee, please help me. I wrote an Audit Trail Log for my application, i needed a simple approach, and a function that i only need to write once and copy/paste it without changes to my forms. This is what i did. I used the function getFieldNames() and getFieldValue() to get all the fields and values in any given form without having to specify each
DAte field question
I have a begin date and need to calculate my end date by a third field containing the quantity of months. How would this be done? I have been trying (and failing) for a few days and know it must be something obvious but I need help. Thank you so much for your assistance!
Error occured please contact application owner.
The attached is an error msg if one of my user has an input on one of the field of a form. I guess it should be because of a script on user input for that field but I cannot see the error. With my admin access the form works perfectly! Form: Tower_planning Field: Quantity - On Add - On user input
Variable not declared. How I fixed it.
I need to know the number of items in a picklist. So I put a counter in a loop of the picklist like this: count1 = count + 1; Zoho didn't like it. Gave the error: "variable not declared" So I tried putting this before the loop: count1 = 0; Lo and behold, that solved the error.
Performance
Is there anywhere to check current server status? I am experiencing very slow response times while both editing and using my app. Are you aware of any problems?
Dynamic picklist updates on manual entry, but not on scripted entry to reference field.
Hello, I have a form with 2 lookup-picklists ("A" and "B"). First the picklist A selects a record from a database. An OnAdd / Success script for this picklist uses the selected value to populate two fields (field1 and field2) with information extracted from the selected value. The second lookup-picklist (picklist B) uses the values in the two fields to create a dynamic picklist to further select records from the same database based on criteria for the picklist that filters against fileds1 and 2..
Adding 2 formula fields ( Solved By me :)
Is there a way to add 2 formula fields?
Lookup on edit android app issue
Hello, When I edit a record from the android app all the info in lookup fields is lost. Any ideas???? Thanks
Adding data to a multi-select lookup field
I have a multi-select lookup field (Email_To) which contains the ID for a table of Persons. I am trying to set the value of this field to the ID of a person record. What am I doing wrong? for each sales_enquiry_record in Sales_Enquiries [(Created < "01-Jan-2006") && (Email_To is null)] { sales_enquiry_record.Email_To.add(sales_enquiry_record.Person); }
Sub forms in a view
Hi I have a view in which I display a column from a sub-form. I would like to filter the sub-form records which are shown dependent on a value in the sub form. Is this possible? Thanks Craig
Formatting a number field
I have tried to follow previous posts on this subject, but don't have enough programming skills to make things work. In short, I have a number field. I want to add "," as a thousands separator. eg 210000000 becomes 210,000,000 If I understand right, I have to create a second field (single line text) and call the input value from the numeric field, then convert it to a string and add the commas. I've tried everything, but an make this work. My numeric field is called <non_Comma> and my text field
Read Text Field and get the sum of any currency values?
Hi, Is there a way to analyze a text field and then use a function to get the Sum of any currency values contained in the text field? Thank you very much.
Google Ical Feeds Not Working
All of sudden, my Ical feeds to Google Calendar are not updating. I have been using the same ical feeds for several years and they have been fine. The same feeds to a Zoho Calendar are updating correctly. Has anyone else seen this issue
Setting null to variable
Hello!I need to set different pairs of fields, depending on the user's choice. If the field is not necessary to set, there should be empty. Fields are lookup fields with ID's value. BIGINT type, maybe? I try so: tw = if(input.tBotcl, referencies.states.getIdByEng("onClientHands"), referencies.states.getIdByEng("employee")); te = if(input.tBotcl, null, input.employee); tcl = if(input.tBotcl, input.client, null); insertConfig = insert into changeConfig [ ... tBwhere = tw tBEmployee = te tBClient =
Group Edit
I used to be able to do a search and then click on Group Edit (or something like that) and then make changes to the entire found group. Suddenly I cannot do that. Did I do something wrong ?
Problem in downloading image from Zoho creator.
I have created a form in creator and from this form I want to download the images that i have stored in the zoho view without any tool like zoho client. I want to do this programmatically. Please help me out as soon as possible.
Fetch records from Zoho CRM to HTML View
I have a report (image1) with employee details. Also I created an html view (a table image2) which fetches the employee's data and show them in each cell. My question is, if I have all the employees details in my contacts (Zoho CRM) how can I do the same? How can I add in the E-mail cell the employee's email from the CRM? I understood the tutorial https://www.zoho.com/creator/help/fields/access-crm-fields-in-zoho-creator.html but what is the deluge code to get the email and put it in a cell in my
Can I edit the captcha on the forms? Is there a different type of Captcha than the one automatically available on the form?
My users are having trouble reading the captcha and are not submitting the form. Is there an alternative to captcha on the forms? An simple addition 3+6=?, or a JS created-checkbox? Please advise.
How to add existing CRM object with the new application
Hi, I am creating a new application in Zoho creator. I want to pull the accounts tab to be displayed along with the other objects/Forms in the new application. How can I achieve that?
Look Up auto complete
Hi I am having some probably simple issues. I would like to have an autocomplete field. I have a customer list of some 5000 customers and want to be able to have a single line field (not a drop down, there would be thousands of drop downs). When you start typing it narrows down the search to auto populate, like in Zoho CRM accounts etc. I am a bit new to this but have set up a new form with the customers and cannot work out how to do the rest. Thanks in advance. Michael
Next Page