Update values in the table based on another table.
I have a table(Stock) where the values are populated from an import excel option (say 10 records). I have added an additional field in the form for ModelCode. Now the value for the ModelCode in the Stock Report is empty. Another table(Products) has the value for ModelCode. Based on the condition as model no same in both the tables, i were to update values to the Stock table for ModelCode. Pls suggest me how can i do it.. Thanks in advance.
Pasting in FreeFlow gives a Null error
I am trying to make a near duplicate of a form. I went to FreeFlow scripting and when I paste in a working segment from the original form it gives me a null error when I try to save. I am just trying to do segments in the Form Definition without Action. I don't remember this behavior 4 months ago. My brackets are correct. The new form is a stateless version of a state form.
Comparison Website with user logins
We need to make a comparison website to compare features of around 5000 products. This will be based on type of product and then model comparison within a type. Users will be able to get registered to the website for detailed features. Therefore this website will be based on a database which will hold types of products, models of products, manufacturers, suppliers and different types of users (with different user levels) Professional with similar portfolio please contact ASAP Many thanks
how - view field but can't edit?
hi for app there is few users who works with incoming entries. need functionality: 1) for new incoming entry there is auto-fulfillment of entries (already works) 2) user for assigned to him view can open and edit entries (already works) 3) how can i make access restrictions for fieldA so that user can open and view inside this fieldA, but can't to edit text of this field ? example - fieldA is phone field. this field auto fulfilled via web-site. user can open entry and view all data, but he can't
Dynamic Picklist based on radio button selection
I can't get the following code to work. if (count(Surface[Type == "Film"]) == 0) { clear Top_Surface; } else { film = Surface [Type == "Film"] sort by Type ; Top_Surface:ui.add(film.Film_Tafetta.getall()); } It seems if i change the above code to the below code, i do not get an error but i have another problem instead. if (count(Surface[Type == input.Membrane_Configuration]) == 0) { clear Top_Surface; } else {
Reports module in Zoho Creator is not working properly after adding a field from another table to a report
I have problems with reports based on a "Transactions" table. For instance, the reports and graphs don´t show all values in the field "State" and the aggregation of a column "Amount" is not given the same results compared with the same operation made directly over the table view. The problem arouse after I added a column called "budget" to the table, which is the ID to link to a new table where we have another field called "budget amount" (money type). After that I developed a new report based
Help. Form should trigger invoice, however on public hosted website this isn't happening.
Hi Team I have an inspection booking form in ZC. This form creates an invoice in ZI and sends it to the client on submission of the form. This works perfectly if I run it in the same browser as my admin account. However, if I submit this form from a clients machine (or any other computer) the invoice is not created. I can only presume this is a security issue. What security settings do I need to set to allow a form that is publicly hosted to generate an invoice? My account is under vic@thepestmanager.com.au.
Fetch Records Explanation
I am not familiar with coding and I'm having some trouble understanding the Zoho documentation for how to fetch records. Would someone be so kind as to break down this function for me in a way that is easier to understand than what Zoho documented?
Improve connection between Notes and Tasks
Apologies if this has already been raised - could not find any reference to it. Currently in ZohoCRM Notes and Tasks are two separate areas. As a work flow, it is common that while entering Notes there is usually a direct Task that needs to be added as an Action . As an improvement, it would be cool to invoke a Task directly from within the Notes section and link them too, to avoid having to close and save the Note and then start a Task separately. (Currently if you maintain lots of notes on a
WHY is Developer Status No Longer Available??
WHY is Developer Status No Longer Available??I have been a developer for 2 1/2 years. I have always had my clients assign me developer status, which makes it very easy to provide on going support. I found out from a new client that Zoho no longer provides developer status for applications. This makes it much more difficult for me. I have to log on to the clients account with their userid and password. This is very unwieldy and cumbersome, and makes the clients uneasy about security. Existing clients
Eliminate Table Borders in Rich Text
Hi, I create tables through code in rich text fields to get data to line up. It works well, but I cannot find a way to eliminate the borders. Any suggestions? Bruce "Speedy G" Peaslee The World's Fastest Programmer
Update parent status
I have two forms, Vehicle and Log. Vehicle form has two fields...VehicleNumber and Status while the Log form has Employee, CheckOut Date, CheckIn Date, and VehicleNumber (lookup) as the fields. Now every time I check out a vehicle to an employee using the Log form, I want to update the Status field to 'Out' in the Vehicle form. We just signed up for Zoho and I am trying to come to terms with Deluge scripting and its syntax. Appreciate if anyone can help me get started with the code.
Sharing data between Managers and Line Staff
Hello, I created a new inventory database with a Form with that has all of the fields that the Managers want to track. Now I need to give Line Staff access to some of the inventory fields and hide the rest. Do I create another form pointing to the master inventory Form? How can I achieve this? Iram
Create list of record IDs selected from a Lookup Multi-Select field
What field type would hold a list of the ID numbers of records selected from a Lookup Multi-Select field, and what does the script look like to create that list upon user input at that Lookup Multi-Select field? As always, I super appreciate the help offered here. Practically speaking, what I want to do is to reset records that were updated via the Multi-Select field when the form was first created, that in Edit mode have been de-selected.
QR Codes or bar codes integration to zoho....
Is it possible to integrate some sort of bar code scanning into a zoho create application? What I am thinking is using this website http://qrcode.kaywa.com/ to input a comma delimited record from zoho to create a QR code. That code could be printed and placed on a product. Someone would scan the code that is on the product with their phone and then email the record to zoho creator application. You can email records that get input into zoho creator application correct? What they would be emailing
update a row
I am new to zoho. i have been trying to learn about zoho since two weeks. currently i am working with zoho creator where i created an application(Employee Management). In the application i have a form where there are fields as follow: serial number as an auto number field Email as an Email field Date as Date field Is Entering or Leaving as radio field(options: Entering and Leaving) Arrival time as single line field Departure as single line field while accessing the application user has to enter fields
ZH Creator to ZH Invoice integration
New to ZOHO creator ... I'm using zoho.invoice.createinvoice () in ZOHO creator. All works fine in test and I can create an invoice in my own ZOHO Invoice account, however I need my application to create invoices in other ZOHO Invoice accounts. I can also do this using the appropriate ZOHO Invoice API, using AuthToken and API key, but don't necessarily want to do this. Is there any similar way that I can use zoho.invoice.createinvoice () to create an invoice in any (authorised, obviously!) ZH Invoice
How to update a list
Class_Numbers is a multiple-select variable There's no built-in function to actually add a new value to the list. for each student in Attendance [(Clock_Out is null)] { student.Class_Numbers = student.Class_Numbers.add(some_value); } Cheers, John Whitney
Count number of records that match criteria
I have a form where employees put in tickets when they break their devices, what i'm trying to accomplish is to make a label that shows on the form the amount of times that particular employeeID has broken a device (by counting the amount of records that exist with that employeeID) input.lbl_Broken_Count = Service_Ticket_Entry[Employee_ID == "input.Employee_ID"].count(); I read the count function and came up with the above code however when i try to save i'm given the below error: Variable 'lbl_Broken_Count'
Subform fields not calculating
Hello, I created a form called "Add Sale Subform" then I added a Lookup field to it so that I could add it as a Subform to a main form. In each of the fields in the Subform I added the below expression on User Input. input.Amount = (input.Qnty * input.Part + input.Labor - input.Discount); The updating works fine when I open the form separatly from the main form. But when I open the Main form where this subform is connected the subform fields don't update when modifying them. I tried changing
Disable fields based on logged in email address
Hello, I would like to add a formula to the On Load of a form to disable the below fields based on if their loginID equals any of the following hard coded email addresses: johndoe@yahoo.com, janedoe@hotmail.com, DaveJohn@outlook.com I will enter the real email addresses later. Serial_Number Model_Number Date_Received Could you help me with this script?
Formula field not adding up
Hello, I have a formula field field called "Total" withe following expression (Sub_Total + CC_Debit_Fee) Both of the above fields are currency fields, the Sub_Total is updated by fields in subform. But for some reason the formula field doesn't do anything when I enter information in the two fields. It just stays blank. What is wrong with the formula field? Iram
Look up Field in Form Not Filtering in Response to Critera
I have a Lookup field in a form that is not responding to changes in criteria. Regardless of what I put in as criteria the results remain unchanged as if I did nothing. You have access to my application named: PDmobile The form is: EvBroccoli Thanks for any help.
some lookup still return actual value rather than ID
Hi All, I still have two lookup fields that return actual value; all other lookup return ID. It gets confusing sometimes but not a problem. i'm just curious anyone know why?
Field On User Input trigger not executing
The on user input trigger for a field in a form that was working several months today no longer seems to work. When data is entered into the field (any field with an on user input trigger) the user interface shows the spinning icon showing that the back end is processing the trigger -- but the trigger never finishes. I have changed the figure to simple put text into another field on the form and I get the same result. Has anyone else had this problem? Any ideas how to even begin to debug this?
'row' is invalid collection error
I have a form and on this form I dragged in a subform from the buttons, then I added the below script to each of the subform fields that contribute to the Sub Total. All worked well. However then I decided that I needed the other type of subform where I have a linked field so I created a new form with the subform fields that I needed then added it to my main form with the linking. Then I added the below code to the Qnty field and clicked Save Script, and got the below error: Error at line number
Give ownership of app to someone else
Hello, I have developed an Zoho app for a friend in my account but now I want to transfer complete ownership to him. My buddy and I both have the $10 zoho creator paid subscription. How do I do this? Iram
Picking a specific value from a list in Deluge
We have used Creator to create a kind of CRM that links contacts (customers, in our case teachers) with interactions (in our case, usually some kind of field trip or outreach program). To facilitate this, we have a bidirectional relationship between 'Teachers in attendance' on the Interactions form, and 'Interactions' on the Contact form. It works pretty well, as this allows us to view all of the times a given teacher has worked with us over the years. However, as each related field from the interaction
SQL Server to Zoho Interface/Integration
I have a client with a mission-critical SQL Server-based application. The application is not going to migrate to a new platform for the foreseeable future. However, they do want to build a customer portal that would give customers access to order status information and also enable customers to enter orders. Naturally, of course, Zoho comes to mind for that customer portal. Our expectation is that the Zoho portal app would have its own database separate from the SQL Server system - and that the
custom interface button?
hi how can i make new button on creator interface and tune this button to make specific workflow for picked entries? example this button for picked workflow will be change each entry settings and save them
Backed up App but can't import
Hello, I recently backed up one of my apps then downloaded the .zip backup file. Then I logged into another Zoho Creator account and didn't know how to import the app and all its data in one fell swoop. Could you tell me how to do this?
Long function statements
This works: exchange_rate_map = exchange_rate_record.Rates.toMap(); return exchange_rate_map.get(input.Currency_Code).toDecimal(); This saves OK but fails at runtime: return exchange_rate_record.Rates.toMap().get(input.Currency_Code).toDecimal(); Any ideas?
How can I tell how my form and subform are related
Hello, I have a form. On this form I created a subform by dragging the subform button. Then if I remember correctly I used the blank subform. Then I created the fields manually in the subform. But now I would like to know how is the main form and subform related. What if I enter subform records in the wrong record and want to move the subform records to another record? If I new what the related field was and if it was visible I assume I could just change the related field in the subform and the record
301 response code when adding a record to a form in zoho creator
Hi guys, I updated a python script I use to add records to a form I have on zoho creator. I use the new url schema https://creator.zoho.com/api/<ownername>/<format>/<applicationName>/form/<formName>/record/add/ instead of the old one https://creator.zoho.com/api/<format>/<applicationName>/<formName>/add/ and it returns 301 as response code all the time. The authoken is valid and I removed the old field zc_ownername. Any ideas on how to fix it? Cheers
Saving Map Data
I have created a map variable for exchange rates accessed from a live web feed. How do I save a Map variable in a form?
New Built in String function(string.matches(<regular expression>))
We have introduced new string function matches for testing if the string matches a given regular expression. This function will be useful validating a given string for particular format. For ex, following code snippet can be used to validate a phone number string for the formats - (123)456-7890, 123-456-7890, 1234567890, (123)-456-789, (123) 456 7890, 123.456.7890, (123).456 7890 phone = "(123) 456 7890"; if(phone.matches("^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$") == false) { info "Please
email description, not record id
hi there is complex app number of service tables and one main app in main app there is some conditional lookups (for records from service tables) when using main app - user picks records all works good - in main app we can view picked records from service tables (names/descriptions) but when zoho via workflow sends email - in email there is not names/descriptions of picked records but unique id of that records how can i in sendmail send names/descriptions of picked records?
I am trying to use a list field in a formula field, and instead of the text from the list, I get a large number
I have 3 forms. In form 1, I enter a list of hospitals to be use in a Schedule form as a dropdown. In form 2 I enter a list of nurses to be used in a Schedule form as the person being scheduled. In the Schedule Form, I have a drop down, Facility, that is linked to the hospital list form; I also have a field Nurse Name that is linkd to the nurse list form. I then create a formula combining the text of Facility +" "+Nurse Name. Instead of the text I selected from the dropdowns, I get large intergers.
When you embed in HTML-page report from other app, you can't use Add or Edit buttons
HTML-Report: When you embed View from another zoho creator application with Form/Report (not IFrame) - you cant edit or add new elements in this View from this - you always get empty popup window with message: "There is no such form in Zoho Creator ". It's beacuse you use short links for add and edit like "#Form:form_name_from_another app" to get form in popup window, and it's not working from another application Do you plan to fix it?
Error Msg: "Wrong DataType specified. The Template Variable null should be of type LIST."
Hi Folks, I have recently edited a script that was working just fine and now I have hit a problem that I can't solve. I have several Multi-Select dropdown lists with data type stringlist. I wish to set this field to null. In my script, if I enter "input.Task_Fertiliser_Supplier = null;" then the script saves with no error. However, when my program runs, I get the following error message: Error details: - Error Executing the workflow On User Input scrip of Task Type. -- Wrong Data Type specified.
Next Page