Displaying All Fields in a Subform When Viewing Report
I have created a form that is going to be used to track employee goals. The form itself has information about the employee and manager, and then there is a subform field that is used to list individual goals and related information about each goal. When setting up the associated list report, I checked the box "Create a link to show all fields," for the subform field which then creates a hyperlink for each goal in the report, that when clicked, is supposed to show all the information about that goal.
script issue
Hello, I met an interesting issue today. I had a script in one of my apps which has worked fine so far...nothing has changed as far as I know.... Here is the script: input.Purchase_status = "sztornózva"; storno = insert into Purchase_form [ Added_User=zoho.loginuser Supplier_name=input.Supplier_name Invoice_number=input.Invoice_number Date_of_purchase=input.Date_of_purchase Net_total=input.Net_total * -1 VAT_total=input.VAT_total * -1 Gross_total=input.Gross_total * -1 ]; for each rec in input.Purchase_details
Performing a lookup and bringing in data from another application
Hi I have two applications; Roles and HR. When a Leaver form is completed in HR, I would like to pull data based on the Job Role Name in the Leaver form and add in Leavers_Instructions. So the list of Job Role Names is a lookup field from the Roles application. I am guessing i need to get the Unique ID for the Job Role I need and then use that unique ID to pull the Leavers_Instructions value. How would I do this??
Building an app for my company
I would like to create a simple app for our company, that our customers can use. I already have a Google Developers account. My question is: I was searching Zoho , and all I can find is "Forms". ''I want an app that has "Icons" that my customers can click on. Is this possible?
Zoho Creator Single Select Field
Hello everybody I'm looking for a way to create a selection list where I can specify the options, no options that have already been selected should appear in the list. It is about documenting IP addresses. We have a pool of IP addresses. As you can imagine, IP addresses must not be used more than once. If a server has already been assigned an IP address, we don't want the IP address to be available for selection when adding a new server. Is such a thing realisable? Best Regards AINDER
Default Contain value on Field filter in Report
Hy, When we open any Report and click on Filter then all fields shows on Right Side. and when we click on any field then it shows like FIELD NAME and below IS (in drop-down) , i need in place of IS it shows CONTAIN . Is that Possible? if yes then how?
Is Zoho Creator C3 Server is down?
Is Zoho Creator C3 Server is down? no responding, C4, C5 works fine.
adding background image to panel not working
suddenly it doesn't work when i try to add a background image to a panel, i already tried creating a new app, and also with different browsers
Zoho Creator to zoho Books Integration
Hi, I am doing integration from Zoho Creator to Zoho Books. I am able to add records to Zoho Books - Items module when a record is created in Zoho Creator. However, I am not able to search the records from item module. I want to fetch the records using item name and get the id of that item and then in next step update the item details like price and unit. Below is the deluge script i have used but, I am not getting the correct output. Products is a lookup in the stock form. I have used below script
Sum values based on distinct value of another column
Hello, As an example, I am trying to add up the values in one column (Amount $) for each unique value in another column (Item No.) for each Company. Company Item No. Amount ($) A A100 17.60 A A100 17.60 A A101 18.00 B A102 25.00 A A103 17.60 B A104 12.00 B A104 12.00 The Amount ($) will always be the same for the same Item No. but a different Item No. can have the same Amount ($). I am trying to find sum(Amount ($)) but only for unique Item No. (i.e. only add once for duplicates such as A100 and
Entering data directly into Spreadsheet Report
Hello, I find the spreadsheet report very useful seeing that most of us are used to data entering on Excel. Is there an upcoming feature that will allow users to add new records directly in the spreadsheet view and also manipulate data just like in Excel (e.g. highlight, color, etc...)? I've seen other web-based apps that have this feature such as AirTable but I really want it to be implemented in Zoho Creator. Adding new data takes a lot of time especially if you have to access the form (importing
Automatic form-filling for each user, if they don't do it themselves.
So I have an attendance form, wherein people mark themselves as present everyday while submitting the form. I want to write a deluge script in which if a user does not submit the form, the form is automatically filled for the user with the status field marked as absent. So far, I understand that it will be a scheduled workflow based on an hour of the day, where if the script does not find an entry for a user on the current day, a form will be auto-filled for all the relevant users with the status
Compare two lookup lists
What is the best way to achieve the following: (a) I have a data inventory form, and each record tells me whether a certain assurance activity should be undertaken by the data it holds. For instance the data says a special audit should be undertaken. (b) I have a second form which details the special audits that have occured. As an audit can cover multiple data inventory records under (a) the ID's of the records from form (a) covered by the audit are recorded as a list on form (b) - call it b_in_scope_records
Deluge Scrip Zoho CRM and Creator Integration
I'm attempting to write a simple script to pull data from Zoho CRM (Potentials) into a Creator form. Note: I want to pull all data from all fields and display those in Creator. I'm using the following script, and I'm getting the error below when I run the application. Thoughts from the community. contact_map = Map(); contact_map = zoho.crm.getRecords("potentials"); input.Test_App = contact_map.get("Created_By"); Error details: log messages Invalid client task found corresponding properties Line:(3)
Lookup field point to address field show multiple entry of the same value
Hello guys I have a vendor form with the address field. This form have multiple vendors on the same city, so the country, state, and city are the same for many of them, only the street change. Let's say I have 10 vendors in Canada, and 5 in Australia If I create a lookup field that point to that form and to the address field, I have a list of addresses. If I remove all the fields and choose to show only the country, of course I will have a dropdown that show the word Canada 10 times. How can I show
Delete files from "My Library" in page builder
According to this help article https://www.zoho.com/creator/newhelp/pages/configure_image_library.html it's not possible to delete files once they have been uploaded to the image library. I'm tidying up an app and want to delete some images. Can this be done somehow in spite of the bizarre statement that it can't be? Thanks!
Whatsapp Integration
Hello, Is it possible to integrate whatsapp with application on zoho creator?? Thanks & Regards
creating a list report
Hi, My customers give their orders on weekly basis. I'd like to create a list of those customers who have not ordered yet. Anyone could help me how to do that? Kind regards George
Display fields in Zoho Creator from Zoho CRM
I would like to populate a database in Zoho Creator with fields from Zoho CRM. I know I can include some standard fields through the "Integration" but I have other customer fields in CRM that I would like to include in the database. I would like to display these fields in a report and trigger workflows based on fields changes (in Zoho) which would also change Creator. If deluge is required, syntax would help as I'm not a developer.
Problem Adding SubForm rows via script
Hi there, I am having problem adding SubForm row via script. Scenario : Create_Hotel is the main form 1˚ subform : Create_Season (each row is a season, like "low season from... to...", "high season from.. to..", etc.) 2˚ subform : Create_Rooms (each row is a type of rooms in the hotel and for each type of room I have to copy in the field Create_Rooms.Season_room the value from Create_Season.Season. Same for Create_Rooms.rate_from=Create_Season.from and Create_Rooms.rate_to=Create_Season.to) the
Window type in Search element is changing automatically
Task 1: Created a Search Element in page. Did set a criteria in Filter Chose "Same Window" to open. Result: It was working fine. Task 2: Wanted to change criteria in Filter. Went to Search Configuration. Changed the Criteria in Filter. Problem: "Same Window" which I chosen previously is changing back to "New Window".
Best practice for tracking inventory
Hoy hoy! Question for you all, I'm hesitating between two concepts for tracking inventory and am wondering if anyone have an opinion on the subject. Doesn't really matter how the inventory is been changed (could be through a Sale order, a Shipping statement, a Balance Sheet, etc.), I'm more curious about what you think is the best practice. Option #1 Have a Product form with a field Inventory_Quantity When a product is been sold/bought/lost, etc. update the quantity field directly Option #2 Have
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
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
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); }
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
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.
Next Page