I am having a problem with emails inside a zoho creator Form Action sent to email addresses for my users where I know that I have used the exact email address
I am having a problem with emails inside a zoho creator Form Action sent to email addresses for my users where I know that I have used the exact email address - including using "zoho.loginuserid" both with and without the quotation marks. The user does not receive the email, I am sending out several different emails from the same field - is there a limit to the number of emails one can send from a single Form Action? Inside this Form Action I have another email that I send to myself and I do get
Send Mass Email to Customer
Hi Everyone! I have a portal customer and i want to send a mass email when i import some data on a form. The data cointains number that are related with pay invoices. For example: This NumDoc is relate to some email customer, so when I import the csv, i need that send an email to the customer that indicates that the invoices was paid. The currently code that i made is the below, but send me email by all the records. rec_acc = Dream[Doctype == input.DocType && NumDoc == input.NumDoc]; rec_rut = Vendors[Account
Uploading photos as fields in a Zoho Creator Template
I have an application where one of the fields is designed to store the photo of a user. I used the image category field and the system seems to accept it when I load from a JPEG on my PC - it identifies the jpeg and assigns a number on the screen. However, when I look in the Report, the JPEG is not there. When I edit the record and I add the same JPEG in edit mode, it does accept the JPEG and the the JPEG does appear when I view the edited record in the Report view. Attached is a screen capture of
Create customised views in Creator 5
Hi guys, I’ve been using Creator for 7 years and one of my main applications is still in a very old version of Creator. This works perfectly for me because I have a number of users that work across departments and I can share customised views of relevant data with them very easily. Each of my users can work in more than one department and therefore need to be able to see all the data relevant to them. Example: Tom works in Department 1, Department 2 and Department 3. Sarah works in Department 1 and
Filter lookup to select only most recent
Hello, I have a lookup field where I want to select ONLY the most recent record that fits certain criteria. For example, if a customer renews their service plan, I may have two records that filter to [Customer_Name == input.Customer_Name && Transaction == "Purchase Service Plan"] and I'd like to select the one with the most recent Date. Is there a way to do this? Thanks, Elizabeth
Popluate a drop-down list with data from another database
Popluate a drop-down list with data pulled from a database that is maintained by another form....Does anyone know how to do this?
Update Records When in Created or Edited
Hi, I have 2 forms 1) Inward 2) Stock Report Both forms deluge code is under created or edited format. When i enter the record and successfully submit the record data is mapped to Stock Report. Following is the Code i am using if(Inward_Type == "Fabric") { for each rec in Fabric_Inward { duplicate_Record = insert into Fabric_Stock_Master [ Added_User=zoho.loginuser Design_No=rec.Design_No Shade_No=rec.Shade_No Meter=rec.Meter Quality=rec.Quality Width=rec.Width Count_Construction=rec.Count_Construction
Updating Data based on fields
I am trying to get this to work. Keeps giving error. Need to update daily the number of days a home has been listed based on todays date and a date input on the form. Was trying to do it using a daily schedule, but also ok to do it with a buttom I will push every day... but can not get it to work. What am I doing wrong? Keep getting the "Improper Statement" error. for each Days in STR_house_estimates [ ] { Days.Days_on_market = ((zoho.currentdate - Days.Date_listed)) / (1000 * 60 * 60 * 24); }
Feature Request: Better Import Interface
Hi, Hope you are well. I know that you have made significant improvements to your import interface recently. However, I would like to suggest that you try to replicate the Zoho Analytics import interface. The Zoho Analytics interface allows you to schedule imports from URLs: At the moment, the way I see it, getting data into Creator for a citizen developer is a manual process. I know that that there are programmatic methods but they are limited: 1. Migration tool - no longer maintained so not suitable
Allow Records to reference records in the SAME table
This would make a MAJOR difference in the usefulness of ZC. I have a hierarchy of offices, a hierarchy of positions, and a current record with a collection of prior records which must remain available. In each of these situations a row needs to reference a row in the SAME table. Without this feature I can't use ZC for any such apps.
How to import data into Zoho Creator from csv file as an Account Name (integrated field)?
I am currently importing data from CSV into my APP in Zoho creator. I have an integrated Account Name (to zcrm) field which I can't see when importing data - but assume id is the fields to use. When I do import nothing shows in the Account Name. How do I import data from csv to populate the Account Name filed?
Building a report displaying only record where 2 fields are different
Hi, I have 1 form Form A, I like to check where 2 fields are identical or not (displaying only the diff would be better) This Form_A has 2 fields: Field_A : text field with content coming from a import Field_B : look up field linked to Form L The Form_L contains 1 text field named Field_L Data in Form L contains all the unique occurrence existing in Form_A / Field_A. As an administrator, I like to get a report of all record with mismatching Field_A / Field_B of Form_A A normal report can only filter
Zoho Customer Portal 2FA / MFA
Is Multi-Factor authentication on the way for customers using the Zoho creator customer portal? We are looking at security improvements and this is on our list. Thank you and kind regards, D
I don't want xml or json file
Hello, I have a problem with the record update. When I post a form with the attribute "action" like this : https://creator.zoho.com/api/user/json/appname/view/reportname/record/update I always get a response in json (or xml if xml is set) file downloading on my machine. Do you know how to block this ? I judt don't want to download this file.
License for Developers
Hi, I am a freelance developer and new to Zoho Creator. License model is confusing. Could you please someone explain the license model for developers like me? For Eg: I have 10 clients. They own the app. I work for them. Which case will fit for my need? 1. I need to purchase one user Creator license. 2. Each of my clients need to purchase one license for me. So it will be 10 license. 3. I can use Developer Zone. So no license needed at all. 4. Is there any other option?
Best way to transfer forms from one application to another
I need to move 12 forms (stateless and normal) to another application. What's the least painful way to do this? I can't find anything on this topic for creator 5, particularly for stateless forms.
Order Form Save and Submit
Hi i am creating an Order Form for Customers. I want to implement a functionality so that customers can SAVE SUBMIT an order. SAVE means data is saved for later review SUBMIT (approve) means we want to purchase this (the Customer user who submits can also be a different user than the user who creates /SAVEs the order) Also is there a functionality if this is SUBMITed to get this somehow digitally signed by the customer How would you approach/solve this? Thank you! Kind regards Lambert
Separate content from a String
Hi All, I have a form with a rich text field and a single record. The field contains email content My second form sends a notification using the fields value as the body of the email, on success. The problem I have is separating deluge (such as + input.anyfield +) from the HTML / content. My code so far: EC = email_form[ID == 45644000002346541]; req = EC.email_content.toString(); sendmail [ from :"zoho@zoho.com" to :"chris@zoho.com" subject :"subject for this email" message :req ] is it possible
More than one attachments in Send Email task
Is it possible to attach more than one file(PDF- Record Summary) in the Send Email task inside Zoho Creator?
There MUST be a way to update records in bulk. But how?
I have created a database with thousands of records. Occasionally, I need to add another field, after which I need to populate those fields for each of the records. I do NOT want to go through each record one by one to update it. The information I need is in a spreadsheet, which can be converted to CSV or TXT file with no problem. The information is numerical, therefore the bulk update option does not work, as that allows you to update records only with the same value. Most databases allow you
Removing Export Options without Embedding
Seems to me we should be able to customize a standard list's export options. Maybe there is something undocumented to add to the report definition? Cheers, John Whitney
Create a calculations form in Creator
Hi there, I have a excel spreadsheet that with user input calculates points needed to reach end point's threshold It consist out of various of things the client can do to achieve this points. Some the client has done already and some still needs to be done. Currently on the spreadsheet everything that needs to be done is in red and everything that has been done in black. Can this be done.
[ZC Platform Solution] Rebranded Mobile App
Regarding the...new...eerff..Platform. \___( -__- ' )___/ What is the plan on offering our apps as rebranded mobile solutions? Since the new platform is supposed to be a rebranded end-to-end solution, will the ZC rebranded apps be available to our clients? I can't find any documentation or hint of such feature in the dev portal. On the same note, Zoho is now offering the very-tempting Zoho Creator Plus with Flow, rebranded mobile app and etc. at a very aggressive price. At the moment ZC Plus
Can't see Script Builder in Page Builder
Hi, When I create or edit a page in Zoho Creator, I can't see the script builder, or any way to get to the script builder. I think it is stuck in Free Flow mode, or I'm just blind!.
When Zoho creator will introduce two way Real time page - database update like google Firebase or angular model
In today's world real time database is necessary and no body want to refresh page manually. here zoho is laggiing behind with others
Error When Uploading ipa using Transporter iOS
When I try to upload an IPA file to submit to the Apple Appstore, I get the following error: ERROR ITMS-90085: "No architectures in the binary. Lipo failed to detect any architectures in the bundle executable." Im not sure how to resolve this error.
Zoho Creator app for multiple stores
I want to create a Zoho Creator app , it will include multiple stores with the ability of store owners to login into the application and we should track their sales, commissions and they can also track their sales by login , i am confused how i can add them as users , if they don't signup for zoho creator , so i will use customer portal but again how can i track the data related to them.
IP Address of internal LAN subnet
I have a published form that I would like to restrict to a certain subnet in our organization's lan. Windows ipconfig gives me the internal ipaddress, but the system field zoho.ipaddress gives me the external public ipaddress. is there any way I can get the internal address on our internal network?
Footer Issue in zoho creator
Hello, Footer is not acting like a footer, it doesn't appear at the end of the page when i try to print the template. So if i have half the page filled with data it will appear half way down the page instead of appearing at the end of the page. Please Help. Thanks
deluge question
Hello, I want to delete all records in a report containing a given string in a Lookup field every Sunday. I can't get the script working. I've tried multiple ways, without success. Could somebody help? Custom Schedules => Deluge => delete from <FORM> [<Name Lookupfield>.contains("<string>")]; Thanks in advance
SUGGESTION - Integration with Excel via Add-On
My team and I have been using Zoho creator for about 6 months and we see a great opportunity in developing a MS Excel Add-On to sync data. What we mean is an Excel Add-On that manages connections between Excel and the online DB. We developed a bunch of Excel reports based on tables from the Zoho Creator DB. As of now, we simply export the tables and we copy and paste them into the excel report. This is not a great way of sharing data because mistakes can occur during the process compromising
How to download/view the file uploaded in other form into current form ?
Hi, I have two forms, Self Appraisal Form & Managers Appraisal Form. In Self Appraisal Form - User X will enter the required details and uploads a supporting document to it. In Managers Appraisal Form - User Y will check the details entered by User X and should download the supporting document uploaded. Pl help me with some code/script to make this possible. Regards, Prasad
Delete Records using Multiple Conditions
Hello, I have "Kids" form where i have design no, shade no and multiple sizes say 28, 30, 32, 34 and so on and they are updated when delivery challan is created. Now i want to delete the particular design no. when all the sizes of the particular design no is reduced to 0.
Pivot Chart / Subforms
Hello, I am not able to use subforms in pivot chart so i think subforms and pivot chart relation is not supported. Are there any future updates on this topic?
SubForm Script Problem After First Row
Hi, i have a form and a subform under it. I save engine records on my main form. and want to add spare parts to sub form. But my script is nor working well after try to add second record to sub form. I try to explain with the image on attachment. Thanks for help.
Body Maps
Hi there I am looking for a bit of help or advice on how to create a form with body maps. Users need to mark areas on an image and add text to correspond with those areas. This needs to be visible when the completed form is viewed/edited. Any help would be greatly appreciated. Nikky
Show text in popup window after successful submission
How can I implement a workflow to show a text information after successfully submitting a form?
Pictures in forms
Hi, I have a requirement to provide choice of design (Checked , striped etc). For this was trying to see if there is a way to display images and get the user to choose. Possible ? Any creative workaround ?
How to autofill an address field based on geo coordinates
I have an excel file with 3 columns Hotel Name, Latitude, Longitude. Is there any way to import in an address field the Latitude and Longitude and at the same time the system to autofill the address, state, city etc based on these coordinates? I know that there are tools in which by giving the coordinates( manually) they return the geocoded address like the below https://www.latlong.net/Show-Latitude-Longitude.html but I do not want to do it one by one for each hotel (and then import the file to
How to refer to a field object by name
Hello, Is there a way to refer to a field object by name? For example, in JavaScript i can refer to a field the following way, but I can't figure out how it's done in Deluge. for each fld in getFIeldNames() { input[fld] = "My Value" // i want to set the value of a field here } Any help would be apprecaited.
Next Page